Class UpdateSelect
Query for update data from select.
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Terrasoft.Core.DB
Assembly: Terrasoft.Core.dll
Syntax
public class UpdateSelect : Update, IParametrizedQuery, ISqlGenerating, ICacheableQuery, ICloneable, IDBCommand
Constructors
UpdateSelect(UserConnection, String, String)
Initializes instance of UpdateSelect.
Declaration
public UpdateSelect(UserConnection userConnection, string schemaName, string alias)
Parameters
Type | Name | Description |
---|---|---|
UserConnection | userConnection | Instance of user connection. |
System.String | schemaName | Name of the table. |
System.String | alias | Alias of the table. |
Properties
SourceAlias
Alias of table to update.
Declaration
public string SourceAlias { get; set; }
Property Value
Type | Description |
---|---|
System.String |
SourceExpression
Source expression for select query.
Declaration
public QuerySourceExpression SourceExpression { get; set; }
Property Value
Type | Description |
---|---|
QuerySourceExpression |
Methods
AddFrom(QuerySourceExpression)
Declaration
protected void AddFrom(QuerySourceExpression sourceExpression)
Parameters
Type | Name | Description |
---|---|---|
QuerySourceExpression | sourceExpression |
From(String, String)
Adds query source expression.
Declaration
public UpdateSelect From(string schemaName, string alias)
Parameters
Type | Name | Description |
---|---|---|
System.String | schemaName | Source name |
System.String | alias | Alias of source table. |
Returns
Type | Description |
---|---|
UpdateSelect | Current UpdateSelect instance. |
GetSqlText()
Returns sql-text of current query.
Declaration
public override string GetSqlText()
Returns
Type | Description |
---|---|
System.String | Sql-text of current query. |
Overrides
Set(String, QueryColumnExpression)
Adds SET expression to query for column with picked alias and expression of column value.
Declaration
public UpdateSelect Set(string sourceColumnAlias, QueryColumnExpression columnExpression)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceColumnAlias | Alias of the column. |
QueryColumnExpression | columnExpression | Expression of column value. |
Returns
Type | Description |
---|---|
UpdateSelect | Instance of current UpdateSelect. |
Implements
System.ICloneable