Class SqlQueryBuilder

A Microsoft SQL implementation of the QueryBuilder class.

Inheritance

System.Object

QueryBuilder

SqlQueryBuilder

Inherited Members

QueryBuilder.ReadLimit

QueryBuilder.EnableReadLimit

QueryBuilder.EnableTableAndColumnEncapsulation

QueryBuilder.EnableDirtyReads

QueryBuilder.TableName

QueryBuilder.Columns

QueryBuilder.KeyColumns

QueryBuilder.GetQuery(QueryType)

QueryBuilder.Append(String)

QueryBuilder.Append(String, Object[])

QueryBuilder.ToString()

Namespace: Cuemon.Data.SqlClient

Assembly: Cuemon.Data.dll

Syntax

public class SqlQueryBuilder : QueryBuilder

Constructors

SqlQueryBuilder()

Initializes a new instance of the SqlQueryBuilder class.

Declaration

public SqlQueryBuilder()

SqlQueryBuilder(String, IDictionary<String, String>)

Initializes a new instance of the SqlQueryBuilder class.

Declaration

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

Parameters

Type	Name	Description
System.String	tableName	The name of the table or view.
System.Collections.Generic.IDictionary<System.String, System.String>	keyColumns	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.

Declaration

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

Parameters

Type	Name	Description
System.String	tableName	The name of the table or view.
System.Collections.Generic.IDictionary<System.String, System.String>	keyColumns	The key columns to be used in this SqlQueryBuilder instance.
System.Collections.Generic.IDictionary<System.String, System.String>	columns	The none-key columns to be used in this SqlQueryBuilder instance.

Methods

GetQuery(QueryType, String)

Create and returns the builded query from the specified QueryType.

Declaration

public override string GetQuery(QueryType queryType, string tableName)

Parameters

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

Returns

Type	Description
System.String

Overrides

QueryBuilder.GetQuery(QueryType, String)

Extension Methods

ConverterExtensions.ParseWith<TSource, TResult>(TSource, Func<TSource, TResult>)

ConverterExtensions.ParseWith<TSource, T, TResult>(TSource, Func<TSource, T, TResult>, T)

ConverterExtensions.ParseWith<TSource, T1, T2, TResult>(TSource, Func<TSource, T1, T2, TResult>, T1, T2)

ConverterExtensions.ParseWith<TSource, T1, T2, T3, TResult>(TSource, Func<TSource, T1, T2, T3, TResult>, T1, T2, T3)

ConverterExtensions.ParseWith<TSource, T1, T2, T3, T4, TResult>(TSource, Func<TSource, T1, T2, T3, T4, TResult>, T1, T2, T3, T4)

ConverterExtensions.ParseWith<TSource, T1, T2, T3, T4, T5, TResult>(TSource, Func<TSource, T1, T2, T3, T4, T5, TResult>, T1, T2, T3, T4, T5)

ConverterExtensions.ParseWith<TSource, T1, T2, T3, T4, T5, T6, TResult>(TSource, Func<TSource, T1, T2, T3, T4, T5, T6, TResult>, T1, T2, T3, T4, T5, T6)

ConverterExtensions.ParseWith<TSource, T1, T2, T3, T4, T5, T6, T7, TResult>(TSource, Func<TSource, T1, T2, T3, T4, T5, T6, T7, TResult>, T1, T2, T3, T4, T5, T6, T7)

ConverterExtensions.ParseWith<TSource, T1, T2, T3, T4, T5, T6, T7, T8, TResult>(TSource, Func<TSource, T1, T2, T3, T4, T5, T6, T7, T8, TResult>, T1, T2, T3, T4, T5, T6, T7, T8)

ConverterExtensions.ParseWith<TSource, T1, T2, T3, T4, T5, T6, T7, T8, T9, TResult>(TSource, Func<TSource, T1, T2, T3, T4, T5, T6, T7, T8, T9, TResult>, T1, T2, T3, T4, T5, T6, T7, T8, T9)

ConverterExtensions.As<TResult>(Object)

ConverterExtensions.As<TResult>(Object, TResult)

ConverterExtensions.As<TResult>(Object, TResult, IFormatProvider)

DelegateUtilityExtensions.Wrap<TResult>(TResult)

DelegateUtilityExtensions.DynamicWrap<TResult>(TResult)

TweakerExtensions.Adjust<T>(T, Func<T, T>)

TypeUtilityExtensions.Is<T>(Object)

TypeUtilityExtensions.IsNot<T>(Object)

TypeUtilityExtensions.IsNullable<T>(T)

WrapperExtensions.UseWrapper<T>(T, Action<IDictionary<String, Object>>)

WrapperExtensions.UseWrapper<T>(T, MemberInfo, Action<IDictionary<String, Object>>)

EnumerableUtilityExtensions.Yield<TSource>(TSource)

HashUtilityExtensions.ComputeHash(Object, Action<HashOptions>)

HmacUtilityExtensions.ComputeKeyedHash(Object, Byte[], Action<KeyedHashOptions>)