C# Class Sql.SqlBuilder

Represent a simple SQL Builder

Public Properties

Property	Type	Description
BuilderSettings	Sql.SqlBuilderSettings

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

Method	Description
AppendQuery ( object key, StringBuilder content ) : void
BuildReplaceInsertQuery ( StringBuilder content ) : void
BuildUpdateQuery ( StringBuilder content ) : void

Append values

public AppendListValues ( IEnumerable
values	IEnumerable	Values
return	void

Append prepared sql query

public AppendSqlQuery ( object key, string format ) : void
key	object
format	string
return	void

Append value

public AppendValue ( object value ) : void
value	object	Value
return	void

Append values

public AppendValues ( ) : void
return	void

Append values

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

Flush Sql.SqlBuilder

public Flush ( ) : void
return	void

Set key

public SetKey ( object key ) : void
key	object	Key value
return	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
return	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
return	void

Initialize Sql.SqlBuilder with specific Sql.SqlBuilderSettings

public SqlBuilder ( ) : System
return	System

Build sql query

public ToString ( ) : string
return	string

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

public SqlBuilderSettings,Sql BuilderSettings
return	Sql.SqlBuilderSettings