C# Class Shaolinq.Persistence.Linq.Sql92QueryFormatter

Inheritance: SqlQueryFormatter

Show file Open project: tumtumtum/Shaolinq Class Usage Examples

Protected Properties

Property	Type	Description
ParamNamePrefix	string
identifierQuoteString	string
ignoreAlias	string
options	SqlQueryFormatterOptions
replaceAlias	string
sqlDataTypeProvider	SqlDataTypeProvider
typeDescriptorProvider	TypeDescriptorProvider

Public Methods

Method	Description
AcquireIndentationContext ( ) : IndentationContext
AppendFullyQualifiedQuotedTableOrTypeName ( string tableName, Action append ) : void
Sql92QueryFormatter ( SqlQueryFormatterOptions options = SqlQueryFormatterOptions.Default, SqlDialect sqlDialect = null, SqlDataTypeProvider sqlDataTypeProvider = null, TypeDescriptorProvider typeDescriptorProvider = null ) : System
WriteQuotedStringOrObject ( object value ) : void

Protected Methods

Method	Description
AppendLimit ( SqlSelectExpression selectExpression ) : void
AppendTop ( SqlSelectExpression selectExpression ) : void
PreProcess ( Expression expression ) : Expression
RequiresAsteriskWhenNoArgument ( SqlAggregateType aggregateType ) : bool
ResolveSqlFunction ( SqlFunctionCallExpression functionExpression ) : FunctionResolveResult
VisitAggregate ( SqlAggregateExpression sqlAggregate ) : Expression
VisitAlterTable ( SqlAlterTableExpression alterTableExpression ) : Expression
VisitAssign ( SqlAssignExpression expression ) : Expression
VisitBinary ( BinaryExpression binaryExpression ) : Expression
VisitColumn ( SqlColumnExpression columnExpression ) : Expression
VisitColumn ( SqlSelectExpression selectExpression, SqlColumnDeclaration column ) : void
VisitColumnDefinition ( SqlColumnDefinitionExpression columnDefinitionExpression ) : Expression
VisitConditional ( ConditionalExpression expression ) : Expression
VisitConstant ( ConstantExpression constantExpression ) : Expression
VisitConstantPlaceholder ( SqlConstantPlaceholderExpression constantPlaceholderExpression ) : Expression
VisitConstraintAction ( SqlConstraintActionExpression actionExpression ) : Expression
VisitCreateIndex ( SqlCreateIndexExpression createIndexExpression ) : Expression
VisitCreateTable ( SqlCreateTableExpression createTableExpression ) : Expression
VisitCreateType ( SqlCreateTypeExpression expression ) : Expression
VisitDelete ( SqlDeleteExpression deleteExpression ) : Expression
VisitEnumDefinition ( SqlEnumDefinitionExpression expression ) : Expression
VisitForeignKeyConstraint ( SqlForeignKeyConstraintExpression foreignKeyConstraintExpression ) : Expression
VisitFunctionCall ( SqlFunctionCallExpression functionCallExpression ) : Expression
VisitIndexedColumn ( SqlIndexedColumnExpression indexedColumnExpression ) : Expression
VisitInsertInto ( SqlInsertIntoExpression expression ) : Expression
VisitJoin ( SqlJoinExpression join ) : Expression
VisitKeyword ( SqlKeywordExpression expression ) : Expression
VisitMemberAccess ( MemberExpression memberExpression ) : Expression
VisitMethodCall ( MethodCallExpression methodCallExpression ) : Expression
VisitObjectReference ( SqlObjectReferenceExpression objectReferenceExpression ) : Expression
VisitOrderBy ( SqlOrderByExpression orderByExpression ) : Expression
VisitParameter ( System.Linq.Expressions.ParameterExpression expression ) : Expression
VisitPragma ( SqlPragmaExpression expression ) : Expression
VisitProjection ( SqlProjectionExpression projection ) : Expression
VisitReferencesColumn ( SqlReferencesColumnExpression referencesColumnExpression ) : Expression
VisitSelect ( SqlSelectExpression selectExpression ) : Expression
VisitSetCommand ( SqlSetCommandExpression expression ) : Expression
VisitSimpleConstraint ( SqlSimpleConstraintExpression simpleConstraintExpression ) : Expression
VisitSource ( Expression source ) : Expression
VisitStatementList ( SqlStatementListExpression statementListExpression ) : Expression
VisitSubquery ( SqlSubqueryExpression subquery ) : Expression
VisitTable ( SqlTableExpression expression ) : Expression
VisitTuple ( SqlTupleExpression tupleExpression ) : Expression
VisitType ( SqlTypeExpression expression ) : Expression
VisitUnary ( UnaryExpression unaryExpression ) : Expression
VisitUnion ( SqlUnionExpression expression ) : Expression
VisitUpdate ( SqlUpdateExpression expression ) : Expression
VisitVariableDeclaration ( SqlVariableDeclarationExpression expression ) : Expression
Write ( SqlColumnReferenceAction action ) : void
Write ( SqlJoinType joinType ) : void
WriteDeferrability ( SqlColumnReferenceDeferrability deferrability ) : void
WriteInsertDefaultValuesSuffix ( ) : void
WriteInsertIntoAfterSource ( SqlInsertIntoExpression expression ) : bool
WriteInsertIntoReturning ( SqlInsertIntoExpression expression ) : void
WriteQuotedIdentifier ( string identifierName ) : void
WriteQuotedString ( string value ) : void
WriteTableName ( string tableName ) : void
WriteTypeName ( string typeName ) : void

Private Methods

Method	Description
GetAggregateName ( SqlAggregateType aggregateType ) : string
IsLikeCallExpression ( Expression expression ) : bool
IsNumeric ( Type type ) : bool

Method Details

AcquireIndentationContext() public method

public AcquireIndentationContext ( ) : IndentationContext
return	IndentationContext

AppendFullyQualifiedQuotedTableOrTypeName() public method

public AppendFullyQualifiedQuotedTableOrTypeName ( string tableName, Action append ) : void
tableName	string
append	Action
return	void

AppendLimit() protected method

protected AppendLimit ( SqlSelectExpression selectExpression ) : void
selectExpression	Shaolinq.Persistence.Linq.Expressions.SqlSelectExpression
return	void

AppendTop() protected method

protected AppendTop ( SqlSelectExpression selectExpression ) : void
selectExpression	Shaolinq.Persistence.Linq.Expressions.SqlSelectExpression
return	void

PreProcess() protected method

protected PreProcess ( Expression expression ) : Expression
expression	System.Linq.Expressions.Expression
return	System.Linq.Expressions.Expression

RequiresAsteriskWhenNoArgument() protected method

protected RequiresAsteriskWhenNoArgument ( SqlAggregateType aggregateType ) : bool
aggregateType	SqlAggregateType
return	bool

ResolveSqlFunction() protected method

protected ResolveSqlFunction ( SqlFunctionCallExpression functionExpression ) : FunctionResolveResult
functionExpression	Shaolinq.Persistence.Linq.Expressions.SqlFunctionCallExpression
return	FunctionResolveResult

Sql92QueryFormatter() public method

public Sql92QueryFormatter ( SqlQueryFormatterOptions options = SqlQueryFormatterOptions.Default, SqlDialect sqlDialect = null, SqlDataTypeProvider sqlDataTypeProvider = null, TypeDescriptorProvider typeDescriptorProvider = null ) : System
options	SqlQueryFormatterOptions
sqlDialect	SqlDialect
sqlDataTypeProvider	SqlDataTypeProvider
typeDescriptorProvider	TypeDescriptorProvider
return	System

VisitAggregate() protected method

protected VisitAggregate ( SqlAggregateExpression sqlAggregate ) : Expression
sqlAggregate	Shaolinq.Persistence.Linq.Expressions.SqlAggregateExpression
return	System.Linq.Expressions.Expression

VisitAlterTable() protected method

protected VisitAlterTable ( SqlAlterTableExpression alterTableExpression ) : Expression
alterTableExpression	Shaolinq.Persistence.Linq.Expressions.SqlAlterTableExpression
return	System.Linq.Expressions.Expression

VisitAssign() protected method

protected VisitAssign ( SqlAssignExpression expression ) : Expression
expression	Shaolinq.Persistence.Linq.Expressions.SqlAssignExpression
return	System.Linq.Expressions.Expression

VisitBinary() protected method

protected VisitBinary ( BinaryExpression binaryExpression ) : Expression
binaryExpression	System.Linq.Expressions.BinaryExpression
return	System.Linq.Expressions.Expression

VisitColumn() protected method

protected VisitColumn ( SqlColumnExpression columnExpression ) : Expression
columnExpression	Shaolinq.Persistence.Linq.Expressions.SqlColumnExpression
return	System.Linq.Expressions.Expression

VisitColumn() protected method

protected VisitColumn ( SqlSelectExpression selectExpression, SqlColumnDeclaration column ) : void
selectExpression	Shaolinq.Persistence.Linq.Expressions.SqlSelectExpression
column	Shaolinq.Persistence.Linq.Expressions.SqlColumnDeclaration
return	void

VisitColumnDefinition() protected method

protected VisitColumnDefinition ( SqlColumnDefinitionExpression columnDefinitionExpression ) : Expression
columnDefinitionExpression	Shaolinq.Persistence.Linq.Expressions.SqlColumnDefinitionExpression
return	System.Linq.Expressions.Expression

VisitConditional() protected method

protected VisitConditional ( ConditionalExpression expression ) : Expression
expression	System.Linq.Expressions.ConditionalExpression
return	System.Linq.Expressions.Expression

VisitConstant() protected method

protected VisitConstant ( ConstantExpression constantExpression ) : Expression
constantExpression	System.Linq.Expressions.ConstantExpression
return	System.Linq.Expressions.Expression

VisitConstantPlaceholder() protected method

protected VisitConstantPlaceholder ( SqlConstantPlaceholderExpression constantPlaceholderExpression ) : Expression
constantPlaceholderExpression	Shaolinq.Persistence.Linq.Expressions.SqlConstantPlaceholderExpression
return	System.Linq.Expressions.Expression

VisitConstraintAction() protected method

protected VisitConstraintAction ( SqlConstraintActionExpression actionExpression ) : Expression
actionExpression	Shaolinq.Persistence.Linq.Expressions.SqlConstraintActionExpression
return	System.Linq.Expressions.Expression

VisitCreateIndex() protected method

protected VisitCreateIndex ( SqlCreateIndexExpression createIndexExpression ) : Expression
createIndexExpression	Shaolinq.Persistence.Linq.Expressions.SqlCreateIndexExpression
return	System.Linq.Expressions.Expression

VisitCreateTable() protected method

protected VisitCreateTable ( SqlCreateTableExpression createTableExpression ) : Expression
createTableExpression	Shaolinq.Persistence.Linq.Expressions.SqlCreateTableExpression
return	System.Linq.Expressions.Expression

VisitCreateType() protected method

protected VisitCreateType ( SqlCreateTypeExpression expression ) : Expression
expression	Shaolinq.Persistence.Linq.Expressions.SqlCreateTypeExpression
return	System.Linq.Expressions.Expression

VisitDelete() protected method

protected VisitDelete ( SqlDeleteExpression deleteExpression ) : Expression
deleteExpression	Shaolinq.Persistence.Linq.Expressions.SqlDeleteExpression
return	System.Linq.Expressions.Expression

VisitEnumDefinition() protected method

protected VisitEnumDefinition ( SqlEnumDefinitionExpression expression ) : Expression
expression	Shaolinq.Persistence.Linq.Expressions.SqlEnumDefinitionExpression
return	System.Linq.Expressions.Expression

VisitForeignKeyConstraint() protected method

protected VisitForeignKeyConstraint ( SqlForeignKeyConstraintExpression foreignKeyConstraintExpression ) : Expression
foreignKeyConstraintExpression	Shaolinq.Persistence.Linq.Expressions.SqlForeignKeyConstraintExpression
return	System.Linq.Expressions.Expression

VisitFunctionCall() protected method

protected VisitFunctionCall ( SqlFunctionCallExpression functionCallExpression ) : Expression
functionCallExpression	Shaolinq.Persistence.Linq.Expressions.SqlFunctionCallExpression
return	System.Linq.Expressions.Expression

VisitIndexedColumn() protected method

protected VisitIndexedColumn ( SqlIndexedColumnExpression indexedColumnExpression ) : Expression
indexedColumnExpression	Shaolinq.Persistence.Linq.Expressions.SqlIndexedColumnExpression
return	System.Linq.Expressions.Expression

VisitInsertInto() protected method

protected VisitInsertInto ( SqlInsertIntoExpression expression ) : Expression
expression	Shaolinq.Persistence.Linq.Expressions.SqlInsertIntoExpression
return	System.Linq.Expressions.Expression

VisitJoin() protected method

protected VisitJoin ( SqlJoinExpression join ) : Expression
join	Shaolinq.Persistence.Linq.Expressions.SqlJoinExpression
return	System.Linq.Expressions.Expression

VisitKeyword() protected method

protected VisitKeyword ( SqlKeywordExpression expression ) : Expression
expression	Shaolinq.Persistence.Linq.Expressions.SqlKeywordExpression
return	System.Linq.Expressions.Expression

VisitMemberAccess() protected method

protected VisitMemberAccess ( MemberExpression memberExpression ) : Expression
memberExpression	System.Linq.Expressions.MemberExpression
return	System.Linq.Expressions.Expression

VisitMethodCall() protected method

protected VisitMethodCall ( MethodCallExpression methodCallExpression ) : Expression
methodCallExpression	System.Linq.Expressions.MethodCallExpression
return	System.Linq.Expressions.Expression

VisitObjectReference() protected method

protected VisitObjectReference ( SqlObjectReferenceExpression objectReferenceExpression ) : Expression
objectReferenceExpression	Shaolinq.Persistence.Linq.Expressions.SqlObjectReferenceExpression
return	System.Linq.Expressions.Expression

VisitOrderBy() protected method

protected VisitOrderBy ( SqlOrderByExpression orderByExpression ) : Expression
orderByExpression	Shaolinq.Persistence.Linq.Expressions.SqlOrderByExpression
return	System.Linq.Expressions.Expression

VisitParameter() protected method

protected VisitParameter ( System.Linq.Expressions.ParameterExpression expression ) : Expression
expression	System.Linq.Expressions.ParameterExpression
return	System.Linq.Expressions.Expression

VisitPragma() protected method

protected VisitPragma ( SqlPragmaExpression expression ) : Expression
expression	Shaolinq.Persistence.Linq.Expressions.SqlPragmaExpression
return	System.Linq.Expressions.Expression

VisitProjection() protected method

protected VisitProjection ( SqlProjectionExpression projection ) : Expression
projection	Shaolinq.Persistence.Linq.Expressions.SqlProjectionExpression
return	System.Linq.Expressions.Expression

VisitReferencesColumn() protected method

protected VisitReferencesColumn ( SqlReferencesColumnExpression referencesColumnExpression ) : Expression
referencesColumnExpression	Shaolinq.Persistence.Linq.Expressions.SqlReferencesColumnExpression
return	System.Linq.Expressions.Expression

VisitSelect() protected method

protected VisitSelect ( SqlSelectExpression selectExpression ) : Expression
selectExpression	Shaolinq.Persistence.Linq.Expressions.SqlSelectExpression
return	System.Linq.Expressions.Expression

VisitSetCommand() protected method

protected VisitSetCommand ( SqlSetCommandExpression expression ) : Expression
expression	Shaolinq.Persistence.Linq.Expressions.SqlSetCommandExpression
return	System.Linq.Expressions.Expression

VisitSimpleConstraint() protected method

protected VisitSimpleConstraint ( SqlSimpleConstraintExpression simpleConstraintExpression ) : Expression
simpleConstraintExpression	Shaolinq.Persistence.Linq.Expressions.SqlSimpleConstraintExpression
return	System.Linq.Expressions.Expression

VisitSource() protected method

protected VisitSource ( Expression source ) : Expression
source	System.Linq.Expressions.Expression
return	System.Linq.Expressions.Expression

VisitStatementList() protected method

protected VisitStatementList ( SqlStatementListExpression statementListExpression ) : Expression
statementListExpression	Shaolinq.Persistence.Linq.Expressions.SqlStatementListExpression
return	System.Linq.Expressions.Expression

VisitSubquery() protected method

protected VisitSubquery ( SqlSubqueryExpression subquery ) : Expression
subquery	Shaolinq.Persistence.Linq.Expressions.SqlSubqueryExpression
return	System.Linq.Expressions.Expression

VisitTable() protected method

protected VisitTable ( SqlTableExpression expression ) : Expression
expression	Shaolinq.Persistence.Linq.Expressions.SqlTableExpression
return	System.Linq.Expressions.Expression

VisitTuple() protected method

protected VisitTuple ( SqlTupleExpression tupleExpression ) : Expression
tupleExpression	Shaolinq.Persistence.Linq.Expressions.SqlTupleExpression
return	System.Linq.Expressions.Expression

VisitType() protected method

protected VisitType ( SqlTypeExpression expression ) : Expression
expression	Shaolinq.Persistence.Linq.Expressions.SqlTypeExpression
return	System.Linq.Expressions.Expression

VisitUnary() protected method

protected VisitUnary ( UnaryExpression unaryExpression ) : Expression
unaryExpression	System.Linq.Expressions.UnaryExpression
return	System.Linq.Expressions.Expression

VisitUnion() protected method

protected VisitUnion ( SqlUnionExpression expression ) : Expression
expression	Shaolinq.Persistence.Linq.Expressions.SqlUnionExpression
return	System.Linq.Expressions.Expression

VisitUpdate() protected method

protected VisitUpdate ( SqlUpdateExpression expression ) : Expression
expression	Shaolinq.Persistence.Linq.Expressions.SqlUpdateExpression
return	System.Linq.Expressions.Expression

VisitVariableDeclaration() protected method

protected VisitVariableDeclaration ( SqlVariableDeclarationExpression expression ) : Expression
expression	Shaolinq.Persistence.Linq.Expressions.SqlVariableDeclarationExpression
return	System.Linq.Expressions.Expression

Write() protected method

protected Write ( SqlColumnReferenceAction action ) : void
action	SqlColumnReferenceAction
return	void

Write() protected method

protected Write ( SqlJoinType joinType ) : void
joinType	SqlJoinType
return	void

WriteDeferrability() protected method

protected WriteDeferrability ( SqlColumnReferenceDeferrability deferrability ) : void
deferrability	SqlColumnReferenceDeferrability
return	void

WriteInsertDefaultValuesSuffix() protected method

protected WriteInsertDefaultValuesSuffix ( ) : void
return	void

WriteInsertIntoAfterSource() protected method

protected WriteInsertIntoAfterSource ( SqlInsertIntoExpression expression ) : bool
expression	Shaolinq.Persistence.Linq.Expressions.SqlInsertIntoExpression
return	bool

WriteInsertIntoReturning() protected method

protected WriteInsertIntoReturning ( SqlInsertIntoExpression expression ) : void
expression	Shaolinq.Persistence.Linq.Expressions.SqlInsertIntoExpression
return	void

WriteQuotedIdentifier() protected method

protected WriteQuotedIdentifier ( string identifierName ) : void
identifierName	string
return	void

WriteQuotedString() protected method

protected WriteQuotedString ( string value ) : void
value	string
return	void

WriteQuotedStringOrObject() public method

public WriteQuotedStringOrObject ( object value ) : void
value	object
return	void

WriteTableName() protected method

protected WriteTableName ( string tableName ) : void
tableName	string
return	void

WriteTypeName() protected method

protected WriteTypeName ( string typeName ) : void
typeName	string
return	void

Property Details

ParamNamePrefix protected static property

protected static string ParamNamePrefix
return	string

identifierQuoteString protected property

protected string identifierQuoteString
return	string

ignoreAlias protected property

protected string ignoreAlias
return	string

options protected property

protected SqlQueryFormatterOptions options
return	SqlQueryFormatterOptions

replaceAlias protected property

protected string replaceAlias
return	string

sqlDataTypeProvider protected property

protected SqlDataTypeProvider sqlDataTypeProvider
return	SqlDataTypeProvider

typeDescriptorProvider protected property

protected TypeDescriptorProvider typeDescriptorProvider
return	TypeDescriptorProvider