UpdateSelect class

Level: advanced

Terrasoft.Core.DB namespace.

The Terrasoft.Core.DB.UpdateSelect class builds queries to modify records in a Creatio database table. The Terrasoft.Core.DB.Select class instance serves as a data source. As a result of creating and configuring the instance of the UpdateSelect class, Creatio will build an UPDATE FROM SQL query.

Constructors

public UpdateSelect(UserConnection userConnection, string schemaName, string alias)

Creates a class instance for the specified schema using UserConnection.

Parameters

userConnection	User connection that the query uses.
schemaName	Schema name.
alias	Table alias.

Properties

SourceAlias string

Alias of the data table to modify.

SourceExpression Terrasoft.Core.DB.QuerySourceExpression

SELECT query expression.

Methods

public UpdateSelect From(string schemaName, string alias)

Adds the FROM expression to the query.

Parameters

schemaName	Name of the table to modify.
alias	Alias of the table to modify.

public UpdateSelect Set(string sourceColumnAlias, QueryColumnExpression columnExpression)

Adds the SET column expression to the query.

Parameters

sourceColumnAlias	Column alias.
columnExpression	Expression that contains the column value.