Class SqlQueryBuilder

Namespace

Cuemon.Data.SqlClient

Assembly

Cuemon.Data.SqlClient.dll

A Microsoft SQL implementation of the QueryBuilder class.

public class SqlQueryBuilder : QueryBuilder

Inheritance

object

QueryBuilder

SqlQueryBuilder

Inherited Members

QueryBuilder.ReadLimit

QueryBuilder.EnableReadLimit

QueryBuilder.EnableTableAndColumnEncapsulation

QueryBuilder.EnableDirtyReads

QueryBuilder.TableName

QueryBuilder.Columns

QueryBuilder.KeyColumns

QueryBuilder.EncodeFragment(QueryFormat, IEnumerable<string>, bool)

QueryBuilder.GetQuery(QueryType)

QueryBuilder.Append(string)

QueryBuilder.Append(string, params object[])

QueryBuilder.ToString()

Constructors

SqlQueryBuilder()

Initializes a new instance of the SqlQueryBuilder class.

public SqlQueryBuilder()

SqlQueryBuilder(string, IDictionary<string, string>)

Initializes a new instance of the SqlQueryBuilder class.

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

Parameters

tableName string

The name of the table or view.

keyColumns IDictionary<string, string>

The key columns to be used in this SqlQueryBuilder instance.

SqlQueryBuilder(string, IDictionary<string, string>, IDictionary<string, string>)

Initializes a new instance of the SqlQueryBuilder class.

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

Parameters

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.

Methods

GetQuery(QueryType, string)

Create and returns the query from the specified QueryType.

public override string GetQuery(QueryType queryType, string tableName)

Parameters

queryType QueryType

Type of the query to create.

tableName string

The name of the table or view. Overrides the class wide tableName.

Returns

string

The result of the builder as a T-SQL query.