Class SqlQueryBuilder

A Microsoft SQL implementation of the QueryBuilder class.

public class SqlQueryBuilder : QueryBuilder

Inherited Members: QueryBuilder.ReadLimit

QueryBuilder.EnableReadLimit

QueryBuilder.EnableTableAndColumnEncapsulation

QueryBuilder.EnableDirtyReads

QueryBuilder.TableName

QueryBuilder.Columns

QueryBuilder.KeyColumns

QueryBuilder.EncodeFragment(QueryFormat, IEnumerable<String>, Boolean)

QueryBuilder.GetQuery(QueryType)

QueryBuilder.Append(String)

QueryBuilder.Append(String, Object[])

QueryBuilder.ToString()

Constructors

Initializes a new instance of the SqlQueryBuilder class.

public SqlQueryBuilder()

Initializes a new instance of the SqlQueryBuilder class.

public SqlQueryBuilder(string tableName, IDictionary<string, string> keyColumns)

tableName String: The name of the table or view.
keyColumns IDictionary<String, String>: The key columns to be used in this SqlQueryBuilder instance.

Initializes a new instance of the SqlQueryBuilder class.

public SqlQueryBuilder(string tableName, IDictionary<string, string> keyColumns, IDictionary<string, string> columns)

tableName String: The name of the table or view.
keyColumns IDictionary<String, String>: The key columns to be used in this SqlQueryBuilder instance.
columns IDictionary<String, String>: The none-key columns to be used in this SqlQueryBuilder instance.

Create and returns the query from the specified QueryType.

public override string GetQuery(QueryType queryType, string tableName)

queryType QueryType: Type of the query to create.
tableName String: The name of the table or view. Overrides the class wide tableName.