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.

Creates a new delete query builder.

public static Delete ( ) : IDeleteFrom
리턴	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.
리턴	IWithParameter

Creates a new insert query builder.

public static Insert ( ) : IInsertIntoTable
리턴	IInsertIntoTable

Creates a new select query with no specified columns.

public static Select ( ) : IFunctionOrFrom
리턴	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.
리턴	IFunctionOrFrom

Creates a new update query builder.

public static Update ( ) : IUpdate
리턴	IUpdate