Interface IQueryInsertBuilder

Creates INSERT Query.

Inherited Members
Namespace: LemonEdge.DataAccess.Core.Abstractions.Builders
Assembly: LemonEdge.DataAccess.Core.Abstractions.dll
Syntax
public interface IQueryInsertBuilder : IQueryBuilder

Methods

AddColumnName(string, bool)

Adds the name of a column to insert into on the mainTable provided in the construction of this class.

Declaration
void AddColumnName(string columnName, bool addAtEnd = false)
Parameters
Type Name Description
string columnName

The name of the column to insert values into.
bool addAtEnd

Indicates if this column should be added at the end of the list of columns when creating the sql statement.

InsertSelectStatement(IQuerySelectBuilder)

Specifies that the values to insert into this table will be provided by a SqlSelectBuilder. If no column names have been added to this InsertBuilder then they are copied from the provided SqlSelectBuilder. You can not use InsertValue if you are providing a SqlSelectBuilder for the values to insert.

Declaration
void InsertSelectStatement(IQuerySelectBuilder sb)
Parameters
Type Name Description
IQuerySelectBuilder sb

A SqlSelectBuilder containing the correct number and types of columns to be inserted into this mainTable.

InsertValue(string)

Specifies a value to insert into this mainTable. The call to InsertValue must be in the same order as the calls to AddColumnName, to ensure the correct values are added into the correct columns. You can not use InsertSelectStatement if you are providing a the values to insert.

Declaration
void InsertValue(string value)
Parameters
Type Name Description
string value

A value to be inserted for the corrosponding column in this mainTable.

Extension Methods