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
Inherited Constructors
SnapObjects.Data.ISqlFromBuilder
SnapObjects.Data.ISqlJoinBuilder
SnapObjects.Data.ISqlWhereBuilder
SnapObjects.Data.ISqlGroupBuilder
SnapObjects.Data.ISqlHavingBuilder
SnapObjects.Data.ISqlOrderBuilder
SnapObjects.Data.ISqlBuilderBase
System.ICloneable<ISqlBuilder>
Syntax
public interface ISqlUpdateBuilder : ISqlFromBuilder, ISqlJoinBuilder, ISqlWhereBuilder, ISqlGroupBuilder, ISqlHavingBuilder, ISqlOrderBuilder, ISqlBuilder, ISqlBuilderBase, ICloneable<ISqlBuilder>;
Method
| 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. |