C# Class NSoft.NFramework.Data.AdoPoco.SqlBuilder

SQL 문자열을 빌드하는 헬퍼 클래스입니다.
Mostrar archivo Open project: debop/NFramework Class Usage Examples

Public Methods

Method Description
Append ( SqlBuilder sql ) : SqlBuilder
Append ( string sql ) : SqlBuilder
From ( ) : SqlBuilder
GroupBy ( ) : SqlBuilder
InnerJoin ( string table ) : SqlJoinClause
LeftJoin ( string table ) : SqlJoinClause
LeftOuterJoin ( string table ) : SqlJoinClause
OrderBy ( ) : SqlBuilder
RightJoin ( string table ) : SqlJoinClause
RightOuterJoin ( string table ) : SqlJoinClause
Select ( ) : SqlBuilder
SqlBuilder ( ) : System
SqlBuilder ( string sql ) : System
Where ( string sql ) : SqlBuilder

Private Methods

Method Description
Build ( ) : void

SQL 문장과 파라미터 정보를 이용하여 SQL 문장을 완성합니다.
Build ( StringBuilder sb, IList args, SqlBuilder lhs = null ) : void

SQL 문장과 파라미터 정보를 이용하여 SQL 문장을 완성합니다.
Is ( SqlBuilder sqlBuilder, string sqlType ) : bool

sqlBuilder 의 내부 Sql 문장에 sqlType의 예약어로 시작하는지 검사합니다.
JoinInternal ( string joinType, string table ) : SqlJoinClause

Method Details

Append() public method

public Append ( SqlBuilder sql ) : SqlBuilder
sql SqlBuilder
return SqlBuilder

Append() public method

public Append ( string sql ) : SqlBuilder
sql string
return SqlBuilder

From() public method

public From ( ) : SqlBuilder
return SqlBuilder

GroupBy() public method

public GroupBy ( ) : SqlBuilder
return SqlBuilder

InnerJoin() public method

public InnerJoin ( string table ) : SqlJoinClause
table string
return SqlJoinClause

LeftJoin() public method

public LeftJoin ( string table ) : SqlJoinClause
table string
return SqlJoinClause

LeftOuterJoin() public method

public LeftOuterJoin ( string table ) : SqlJoinClause
table string
return SqlJoinClause

OrderBy() public method

public OrderBy ( ) : SqlBuilder
return SqlBuilder

RightJoin() public method

public RightJoin ( string table ) : SqlJoinClause
table string
return SqlJoinClause

RightOuterJoin() public method

public RightOuterJoin ( string table ) : SqlJoinClause
table string
return SqlJoinClause

Select() public method

public Select ( ) : SqlBuilder
return SqlBuilder

SqlBuilder() public method

public SqlBuilder ( ) : System
return System

SqlBuilder() public method

public SqlBuilder ( string sql ) : System
sql string
return System

Where() public method

public Where ( string sql ) : SqlBuilder
sql string
return SqlBuilder