C# 클래스 Sql.SqlBuilder

Represent a simple SQL Builder

공개 프로퍼티들

프로퍼티	타입	설명
BuilderSettings	Sql.SqlBuilderSettings

메소드	설명
AppendListValues ( IEnumerable	Append values
AppendSqlQuery ( object key, string format ) : void	Append prepared sql query
AppendValue ( object value ) : void	Append value
AppendValues ( ) : void	Append values
AppendValues ( IEnumerable	Append values
Flush ( ) : void	Flush Sql.SqlBuilder
SetKey ( object key ) : void	Set key
Setup ( string tableName, string key, bool hasPreparedQueries ) : void	Setup Sql.SqlBuilder
Setup ( string tableName, string key, bool hasPreparedQueries, string fields, int count ) : void	Setup Sql.SqlBuilder
SqlBuilder ( ) : System	Initialize Sql.SqlBuilder with specific Sql.SqlBuilderSettings
ToString ( ) : string	Build sql query

메소드	설명
AppendQuery ( object key, StringBuilder content ) : void
BuildReplaceInsertQuery ( StringBuilder content ) : void
BuildUpdateQuery ( StringBuilder content ) : void

Append values

public AppendListValues ( IEnumerable
values	IEnumerable	Values
리턴	void

Append prepared sql query

public AppendSqlQuery ( object key, string format ) : void
key	object
format	string
리턴	void

Append value

public AppendValue ( object value ) : void
value	object	Value
리턴	void

Append values

public AppendValues ( ) : void
리턴	void

Append values

public AppendValues ( IEnumerable
values	IEnumerable	Values
count	int	A specified mumber of contiguous elements from the start of a sequance
리턴	void

Flush Sql.SqlBuilder

public Flush ( ) : void
리턴	void

Set key

public SetKey ( object key ) : void
key	object	Key value
리턴	void

Setup Sql.SqlBuilder

public Setup ( string tableName, string key, bool hasPreparedQueries ) : void
tableName	string	Table name (like creature_template, creature etc.)
key	string	Key name from table
hasPreparedQueries	bool	Value indicating whether to create a query storage/param> /// Fields name
리턴	void

Setup Sql.SqlBuilder

public Setup ( string tableName, string key, bool hasPreparedQueries, string fields, int count ) : void
tableName	string	Table name (like creature_template, creature etc.)
key	string	Key name from table
hasPreparedQueries	bool	Value indicating whether to create a query storage/param> /// A specified mumber of contiguous elements from the start of a sequance
fields	string	Sequance
count	int
리턴	void

Initialize Sql.SqlBuilder with specific Sql.SqlBuilderSettings

public SqlBuilder ( ) : System
리턴	System

Build sql query

public ToString ( ) : string
리턴	string

Gets a Sql.SqlBuilderSettings that contain settings of the current Sql.SqlBuilder

public SqlBuilderSettings,Sql BuilderSettings
리턴	Sql.SqlBuilderSettings