C# Class YesSql.Core.Sql.SqlBuilder

ファイルを表示 Open project: sebastienros/yessql

Public Methods

Method Description
FormatColumn ( string table, string column ) : string
GetSelector ( ) : string
InnerJoin ( string table, string onTable, string onColumn, string toTable, string toColumn ) : void
OrderBy ( string orderBy ) : void
OrderByDescending ( string orderBy ) : void
Select ( ) : void
Selector ( string selector ) : void
Selector ( string table, string column ) : void
Skip ( int skip ) : void
SqlBuilder ( ) : System
Table ( string table ) : void
Take ( int take ) : void
ThenOrderBy ( string orderBy ) : void
ThenOrderByDescending ( string orderBy ) : void
ToSqlString ( ISqlDialect dialect, bool ignoreOrderBy = false ) : string
WhereAlso ( string where ) : void

Method Details

FormatColumn() public method

public FormatColumn ( string table, string column ) : string
table string
column string
return string

GetSelector() public method

public GetSelector ( ) : string
return string

InnerJoin() public method

public InnerJoin ( string table, string onTable, string onColumn, string toTable, string toColumn ) : void
table string
onTable string
onColumn string
toTable string
toColumn string
return void

OrderBy() public method

public OrderBy ( string orderBy ) : void
orderBy string
return void

OrderByDescending() public method

public OrderByDescending ( string orderBy ) : void
orderBy string
return void

Select() public method

public Select ( ) : void
return void

Selector() public method

public Selector ( string selector ) : void
selector string
return void

Selector() public method

public Selector ( string table, string column ) : void
table string
column string
return void

Skip() public method

public Skip ( int skip ) : void
skip int
return void

SqlBuilder() public method

public SqlBuilder ( ) : System
return System

Table() public method

public Table ( string table ) : void
table string
return void

Take() public method

public Take ( int take ) : void
take int
return void

ThenOrderBy() public method

public ThenOrderBy ( string orderBy ) : void
orderBy string
return void

ThenOrderByDescending() public method

public ThenOrderByDescending ( string orderBy ) : void
orderBy string
return void

ToSqlString() public method

public ToSqlString ( ISqlDialect dialect, bool ignoreOrderBy = false ) : string
dialect ISqlDialect
ignoreOrderBy bool
return string

WhereAlso() public method

public WhereAlso ( string where ) : void
where string
return void