ISqlUpdateBuilder Interface

.NET Standard 2.x

Represents an object used to build a SQL UPDATE statement.

The SQL UPDATE statement can be used to change the existing data in a table or view.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

public interface ISqlUpdateBuilder : ISqlFromBuilder, ISqlBuilder;

Name	Returns Type	Description
Set(string columnName, ISqlParameter parameter)	`ISqlUpdateBuilder`	Adds a column to be updated and specifies a SQL parameter to be updated to the column.
Set(string columnName, string clause)	`ISqlUpdateBuilder`	Adds a column to be updated and specifies the raw SQL to be updated to the column.
Set(string columnName, ISqlBuilder queryBuilder)	`ISqlUpdateBuilder`	Adds a column to be updated and specifies the SQL subquery (specified by an `ISqlBuilder` object) to be updated to the column.
SetRaw(string setRaw)	`ISqlUpdateBuilder`	Specifies one or more columns whose data will be changed and the values of these columns by a raw SQL.
SetValue(string columnName, object value)	`ISqlUpdateBuilder`	Adds a column to be updated and specifies the value to be updated to the column.
Update(string table)	`ISqlUpdateBuilder`	Creates a SQL UPDATE statement and specifies the name of the table or view from which the rows are to be updated.
Update(string table, string schema)	`ISqlUpdateBuilder`	Creates a SQL UPDATE statement and specifies the name and schema of the table or view from which the rows are to be updated.