ISqlInsertBuilder Interface

.NET Standard 2.x | Current Version (1.0.1)

0.5.0-alpha 1.0.1 (current)

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

Syntax

 public interface ISqlInsertBuilder : ISqlBuilder, ISqlBuilderBase, ICloneable<ISqlBuilder>;

Method

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.