ISqlInsertBuilder Interface
.NET Standard 2.x
Represents an object used to build a SQL INSERT statement.
The SQL INSERT statement can be used to add one or more rows to a table or a view in the database.
Namespace: SnapObjects.Data
Assembly: SnapObjects.Data.dll
Inherited Constructor
Syntax
public interface ISqlInsertBuilder : ISqlBuilder;
Methods
| Name | Return Type | Description |
|---|---|---|
| Column(string columnName, ISqlParameter parameter) | ISqlInsertBuilder | Inserts dynamic data into the column of a table. The dynamic data will be specified by a SQL parameter when the SQL is executed. |
| ColumnValue(string columnName, object value) | ISqlInsertBuilder | Specifies the value to be inserted into the column of a table. |
| Insert(string table) | ISqlInsertBuilder | Inserts a row (by a SQL INSERT statement) and specifies the name of the table or view that will receive the data. |
| Insert(string table, string schema) | ISqlInsertBuilder | Inserts a row (by a SQL INSERT statement) and specifies the name and the schema of the table or view that will receive the data. |