C# Class MicroLite.Builder.SqlBuilder

A helper class for building an SqlQuery.

Méthodes publiques

Méthode	Description
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.

Creates a new delete query builder.

public static Delete ( ) : IDeleteFrom
Résultat	IDeleteFrom

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.
Résultat	IWithParameter

Creates a new insert query builder.

public static Insert ( ) : IInsertIntoTable
Résultat	IInsertIntoTable

Creates a new select query with no specified columns.

public static Select ( ) : IFunctionOrFrom
Résultat	IFunctionOrFrom

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.
Résultat	IFunctionOrFrom

Creates a new update query builder.

public static Update ( ) : IUpdate
Résultat	IUpdate