C# Класс MicroLite.Builder.SqlBuilder

A helper class for building an SqlQuery.
Показать файл Открыть проект

Открытые методы

Метод Описание
Delete ( ) : IDeleteFrom

Creates a new delete query builder.
Execute ( string procedure ) : IWithParameter

Species the name of the procedure to be executed.

If the stored procedure has no parameters, call .ToSqlQuery() otherwise add the parameters (see the WithParameter method).

Insert ( ) : IInsertIntoTable

Creates a new insert query builder.
Select ( ) : IFunctionOrFrom

Creates a new select query with no specified columns.
Select ( string column ) : IFunctionOrFrom

Creates a new select query with a single specified column or '*'.
Update ( ) : IUpdate

Creates a new update query builder.

Описание методов

Delete() публичный статический Метод

Creates a new delete query builder.
public static Delete ( ) : IDeleteFrom
Результат IDeleteFrom

Execute() публичный статический Метод

Species the name of the procedure to be executed.
If the stored procedure has no parameters, call .ToSqlQuery() otherwise add the parameters (see the WithParameter method).
public static Execute ( string procedure ) : IWithParameter
procedure string The name of the stored procedure.
Результат IWithParameter

Insert() публичный статический Метод

Creates a new insert query builder.
public static Insert ( ) : IInsertIntoTable
Результат IInsertIntoTable

Select() публичный статический Метод

Creates a new select query with no specified columns.
public static Select ( ) : IFunctionOrFrom
Результат IFunctionOrFrom

Select() публичный статический Метод

Creates a new select query with a single specified column or '*'.
public static Select ( string column ) : IFunctionOrFrom
column string The column (or wildcard *) to be included in the query.
Результат IFunctionOrFrom

Update() публичный статический Метод

Creates a new update query builder.
public static Update ( ) : IUpdate
Результат IUpdate