C# Class MicroLite.Builder.SqlBuilder

A helper class for building an SqlQuery.
Show file Open project: TrevorPilley/MicroLite

Public Methods

Method 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.

Method Details

Delete() public static method

Creates a new delete query builder.
public static Delete ( ) : IDeleteFrom
return IDeleteFrom

Execute() public static method

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.
return IWithParameter

Insert() public static method

Creates a new insert query builder.
public static Insert ( ) : IInsertIntoTable
return IInsertIntoTable

Select() public static method

Creates a new select query with no specified columns.
public static Select ( ) : IFunctionOrFrom
return IFunctionOrFrom

Select() public static method

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.
return IFunctionOrFrom

Update() public static method

Creates a new update query builder.
public static Update ( ) : IUpdate
return IUpdate