Skip to content
Auto
Products

SqlQueryResolver

Namespace: TagBites.Sql
Assembly: TagBites.DB.dll
Product: TagBites.DB v. 1.0.37

public class SqlQueryResolver

Inheritance: object → SqlQueryResolver

Derived:

public SqlQueryResolver()
protected virtual string FalseLiteral { get; }

string

public bool InlineParameters { get; set; }

bool

Number of values sets to include names to.

public int NamedValuesNumber { get; set; }

int

protected virtual string NullLiteral { get; }

string

public virtual bool SupportReturningClause { get; }

bool

protected virtual string TrueLiteral { get; }

string

public bool UseMultilineTrackingComment { get; set; }

bool

protected virtual string GetBuildInFunctionName(string functionName)

string

protected virtual string GetCastString(object value, string typeName)

string

GetOperatorTypeString(SqlExpressionUnaryOperatorType)

Section titled “GetOperatorTypeString(SqlExpressionUnaryOperatorType)”
protected virtual string GetOperatorTypeString(SqlExpressionUnaryOperatorType operatorType)

string

GetOperatorTypeString(SqlExpressionBinaryOperatorType)

Section titled “GetOperatorTypeString(SqlExpressionBinaryOperatorType)”
protected virtual string GetOperatorTypeString(SqlExpressionBinaryOperatorType operatorType)

string

GetOperatorTypeString(SqlConditionBinaryOperatorType)

Section titled “GetOperatorTypeString(SqlConditionBinaryOperatorType)”
protected virtual string GetOperatorTypeString(SqlConditionBinaryOperatorType operatorType)

string

GetOperatorTypeString(SqlConditionGroupOperatorType)

Section titled “GetOperatorTypeString(SqlConditionGroupOperatorType)”
protected virtual string GetOperatorTypeString(SqlConditionGroupOperatorType operatorType)

string

public virtual Query GetQuery(IQuerySource querySource)

Query

public virtual string GetTypeName(DbType dbType)

string

public virtual string GetTypeName(Type netType)

string

public static string QuoteIdentifier(string identifier)

string

RegisterParameterResolver<T>(Func<T, string>)

Section titled “RegisterParameterResolver<T>(Func<T, string>)”
public void RegisterParameterResolver(Func<T, string> parameterResolver)

RegisterParameterResolver<T>(Func<T, SqlExpression>)

Section titled “RegisterParameterResolver<T>(Func<T, SqlExpression>)”
public void RegisterParameterResolver(Func<T, SqlExpression> parameterResolver)
protected virtual string ToDateTimeParameterString(DateTime value)

string

protected virtual string ToEscapedString(string value)

string

public virtual string ToParameterString(object parameter, bool force)

string

protected virtual string ToTimeSpanParameterString(TimeSpan value)

string

public virtual void Visit(object expression, SqlQueryBuilder builder)

VisitClause(SqlClauseWith, string, SqlQueryBuilder)

Section titled “VisitClause(SqlClauseWith, string, SqlQueryBuilder)”
protected internal virtual void VisitClause(SqlClauseWith clause, string keyword, SqlQueryBuilder builder)

VisitClause(SqlClauseSelect, string, SqlQueryBuilder)

Section titled “VisitClause(SqlClauseSelect, string, SqlQueryBuilder)”
protected internal virtual void VisitClause(SqlClauseSelect clause, string keyword, SqlQueryBuilder builder)

VisitClause(SqlClauseValues, string, SqlQueryBuilder, SqlClauseColumns)

Section titled “VisitClause(SqlClauseValues, string, SqlQueryBuilder, SqlClauseColumns)”
protected internal virtual void VisitClause(SqlClauseValues clause, string keyword, SqlQueryBuilder builder, SqlClauseColumns columns)

VisitClause(SqlClauseFrom, string, SqlQueryBuilder)

Section titled “VisitClause(SqlClauseFrom, string, SqlQueryBuilder)”
protected internal virtual void VisitClause(SqlClauseFrom clause, string keyword, SqlQueryBuilder builder)

VisitClause(SqlClauseConditionals, string, SqlQueryBuilder)

Section titled “VisitClause(SqlClauseConditionals, string, SqlQueryBuilder)”
protected internal virtual void VisitClause(SqlClauseConditionals clause, string keyword, SqlQueryBuilder builder)

VisitClause(SqlClauseGroupBy, string, SqlQueryBuilder)

Section titled “VisitClause(SqlClauseGroupBy, string, SqlQueryBuilder)”
protected internal virtual void VisitClause(SqlClauseGroupBy clause, string keyword, SqlQueryBuilder builder)

VisitClause(SqlClauseOrderBy, string, SqlQueryBuilder)

Section titled “VisitClause(SqlClauseOrderBy, string, SqlQueryBuilder)”
protected internal virtual void VisitClause(SqlClauseOrderBy clause, string keyword, SqlQueryBuilder builder)

VisitClause(SqlClauseSet, string, SqlQueryBuilder)

Section titled “VisitClause(SqlClauseSet, string, SqlQueryBuilder)”
protected internal virtual void VisitClause(SqlClauseSet clause, string keyword, SqlQueryBuilder builder)

VisitClause(SqlClauseDistinct, SqlQueryBuilder)

Section titled “VisitClause(SqlClauseDistinct, SqlQueryBuilder)”
protected internal virtual void VisitClause(SqlClauseDistinct clause, SqlQueryBuilder builder)

VisitClause(SqlClauseColumns, SqlQueryBuilder)

Section titled “VisitClause(SqlClauseColumns, SqlQueryBuilder)”
protected internal virtual void VisitClause(SqlClauseColumns clause, SqlQueryBuilder builder)

VisitClause(SqlClauseJoin, SqlQueryBuilder)

Section titled “VisitClause(SqlClauseJoin, SqlQueryBuilder)”
protected internal virtual void VisitClause(SqlClauseJoin clause, SqlQueryBuilder builder)

VisitClause(SqlClauseUnion, SqlQueryBuilder)

Section titled “VisitClause(SqlClauseUnion, SqlQueryBuilder)”
protected internal virtual void VisitClause(SqlClauseUnion clause, SqlQueryBuilder builder)

VisitClauseEntry(SqlClauseWithEntry, SqlQueryBuilder)

Section titled “VisitClauseEntry(SqlClauseWithEntry, SqlQueryBuilder)”
protected internal virtual void VisitClauseEntry(SqlClauseWithEntry entry, SqlQueryBuilder builder)

VisitClauseEntry(SqlClauseValuesEntry, SqlQueryBuilder, SqlClauseColumns)

Section titled “VisitClauseEntry(SqlClauseValuesEntry, SqlQueryBuilder, SqlClauseColumns)”
protected internal virtual void VisitClauseEntry(SqlClauseValuesEntry entry, SqlQueryBuilder builder, SqlClauseColumns columns)

VisitClauseEntry(SqlClauseFromEntry, SqlQueryBuilder)

Section titled “VisitClauseEntry(SqlClauseFromEntry, SqlQueryBuilder)”
protected internal virtual void VisitClauseEntry(SqlClauseFromEntry entry, SqlQueryBuilder builder)

VisitClauseEntry(SqlClauseOrderByEntry, SqlQueryBuilder)

Section titled “VisitClauseEntry(SqlClauseOrderByEntry, SqlQueryBuilder)”
protected internal virtual void VisitClauseEntry(SqlClauseOrderByEntry entry, SqlQueryBuilder builder)

VisitClauseEntry(SqlClauseSetEntry, SqlQueryBuilder)

Section titled “VisitClauseEntry(SqlClauseSetEntry, SqlQueryBuilder)”
protected internal virtual void VisitClauseEntry(SqlClauseSetEntry entry, SqlQueryBuilder builder)

VisitClauseEntry(SqlClauseJoinEntry, SqlQueryBuilder)

Section titled “VisitClauseEntry(SqlClauseJoinEntry, SqlQueryBuilder)”
protected internal virtual void VisitClauseEntry(SqlClauseJoinEntry entry, SqlQueryBuilder builder)

VisitClauseEntry(SqlClauseUnionEntry, SqlQueryBuilder)

Section titled “VisitClauseEntry(SqlClauseUnionEntry, SqlQueryBuilder)”
protected internal virtual void VisitClauseEntry(SqlClauseUnionEntry entry, SqlQueryBuilder builder)

VisitExpression(SqlLiteral, SqlQueryBuilder)

Section titled “VisitExpression(SqlLiteral, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlLiteral expression, SqlQueryBuilder builder)

VisitExpression(SqlLiteralExpression, SqlQueryBuilder)

Section titled “VisitExpression(SqlLiteralExpression, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlLiteralExpression expression, SqlQueryBuilder builder)

VisitExpression(SqlArgument, SqlQueryBuilder)

Section titled “VisitExpression(SqlArgument, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlArgument expression, SqlQueryBuilder builder)

VisitExpression(SqlTable, SqlQueryBuilder)

Section titled “VisitExpression(SqlTable, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlTable expression, SqlQueryBuilder builder)

VisitExpression(SqlColumn, SqlQueryBuilder)

Section titled “VisitExpression(SqlColumn, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlColumn expression, SqlQueryBuilder builder)

VisitExpression(SqlExpressionFunctionCall, SqlQueryBuilder)

Section titled “VisitExpression(SqlExpressionFunctionCall, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlExpressionFunctionCall expression, SqlQueryBuilder builder)

VisitExpression(SqlExpressionWithAlias, SqlQueryBuilder)

Section titled “VisitExpression(SqlExpressionWithAlias, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlExpressionWithAlias expression, SqlQueryBuilder builder)

VisitExpression(SqlConditionExpression, SqlQueryBuilder)

Section titled “VisitExpression(SqlConditionExpression, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlConditionExpression expression, SqlQueryBuilder builder)

VisitExpression(SqlConditionGroupOperator, SqlQueryBuilder)

Section titled “VisitExpression(SqlConditionGroupOperator, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlConditionGroupOperator expression, SqlQueryBuilder builder)

VisitExpression(SqlConditionBinaryOperator, SqlQueryBuilder)

Section titled “VisitExpression(SqlConditionBinaryOperator, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlConditionBinaryOperator expression, SqlQueryBuilder builder)

VisitExpression(SqlConditionInOperator, SqlQueryBuilder)

Section titled “VisitExpression(SqlConditionInOperator, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlConditionInOperator expression, SqlQueryBuilder builder)

VisitExpression(SqlConditionUnaryOperator, SqlQueryBuilder)

Section titled “VisitExpression(SqlConditionUnaryOperator, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlConditionUnaryOperator expression, SqlQueryBuilder builder)

VisitExpression(SqlExpressionBinaryOperator, SqlQueryBuilder)

Section titled “VisitExpression(SqlExpressionBinaryOperator, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlExpressionBinaryOperator expression, SqlQueryBuilder builder)

VisitExpression(SqlExpressionCastOperator, SqlQueryBuilder)

Section titled “VisitExpression(SqlExpressionCastOperator, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlExpressionCastOperator expression, SqlQueryBuilder builder)

VisitExpression(SqlExpressionUnaryOperator, SqlQueryBuilder)

Section titled “VisitExpression(SqlExpressionUnaryOperator, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlExpressionUnaryOperator expression, SqlQueryBuilder builder)

VisitExpression(SqlExpressionIndexerOperator, SqlQueryBuilder)

Section titled “VisitExpression(SqlExpressionIndexerOperator, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlExpressionIndexerOperator expression, SqlQueryBuilder builder)

VisitExpression(SqlExpressionSelect, SqlQueryBuilder)

Section titled “VisitExpression(SqlExpressionSelect, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlExpressionSelect expression, SqlQueryBuilder builder)

VisitExpression(SqlExpressionQuery, SqlQueryBuilder)

Section titled “VisitExpression(SqlExpressionQuery, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlExpressionQuery expression, SqlQueryBuilder builder)

VisitExpression(SqlOperatorExpression, SqlQueryBuilder)

Section titled “VisitExpression(SqlOperatorExpression, SqlQueryBuilder)”
protected internal virtual void VisitExpression(SqlOperatorExpression expression, SqlQueryBuilder builder)

VisitExpressionWithAlias(SqlQueryBuilder, SqlExpressionWithAlias)

Section titled “VisitExpressionWithAlias(SqlQueryBuilder, SqlExpressionWithAlias)”
protected virtual void VisitExpressionWithAlias(SqlQueryBuilder builder, SqlExpressionWithAlias expressionWithAlias)

VisitLimitOffset(int?, int?, SqlQueryBuilder)

Section titled “VisitLimitOffset(int?, int?, SqlQueryBuilder)”
protected virtual void VisitLimitOffset(int? limit, int? offset, SqlQueryBuilder builder)

VisitParameter(object, object, SqlQueryBuilder)

Section titled “VisitParameter(object, object, SqlQueryBuilder)”
protected virtual void VisitParameter(object parameterOwner, object parameter, SqlQueryBuilder builder)

VisitQuery(SqlQuerySelect, SqlQueryBuilder)

Section titled “VisitQuery(SqlQuerySelect, SqlQueryBuilder)”
protected internal virtual void VisitQuery(SqlQuerySelect query, SqlQueryBuilder builder)

VisitQuery(SqlQueryValues, SqlQueryBuilder)

Section titled “VisitQuery(SqlQueryValues, SqlQueryBuilder)”
protected internal virtual void VisitQuery(SqlQueryValues query, SqlQueryBuilder builder)

VisitQuery(SqlQueryInsertBase, SqlQueryBuilder)

Section titled “VisitQuery(SqlQueryInsertBase, SqlQueryBuilder)”
protected internal virtual void VisitQuery(SqlQueryInsertBase query, SqlQueryBuilder builder)

VisitQuery(SqlQueryUpdate, SqlQueryBuilder)

Section titled “VisitQuery(SqlQueryUpdate, SqlQueryBuilder)”
protected internal virtual void VisitQuery(SqlQueryUpdate query, SqlQueryBuilder builder)

VisitQuery(SqlQueryDelete, SqlQueryBuilder)

Section titled “VisitQuery(SqlQueryDelete, SqlQueryBuilder)”
protected internal virtual void VisitQuery(SqlQueryDelete query, SqlQueryBuilder builder)

VisitTableClause(SqlTable, string, SqlQueryBuilder)

Section titled “VisitTableClause(SqlTable, string, SqlQueryBuilder)”
protected virtual void VisitTableClause(SqlTable table, string keyword, SqlQueryBuilder builder)

VisitTableDeclaration(SqlQueryBuilder, SqlTable, bool, bool)

Section titled “VisitTableDeclaration(SqlQueryBuilder, SqlTable, bool, bool)”
protected virtual void VisitTableDeclaration(SqlQueryBuilder builder, SqlTable table, bool allowExpressions, bool includeAlias)