C# Class Shaolinq.Persistence.Linq.Sql92QueryFormatter

Inheritance: SqlQueryFormatter

Mostra 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_oe static_oe property

protected static string ParamNamePrefix
return	string

identifierQuoteString protected_oe property

protected string identifierQuoteString
return	string

ignoreAlias protected_oe property

protected string ignoreAlias
return	string

options protected_oe property

protected SqlQueryFormatterOptions options
return	SqlQueryFormatterOptions

replaceAlias protected_oe property

protected string replaceAlias
return	string

sqlDataTypeProvider protected_oe property

protected SqlDataTypeProvider sqlDataTypeProvider
return	SqlDataTypeProvider

typeDescriptorProvider protected_oe property

protected TypeDescriptorProvider typeDescriptorProvider
return	TypeDescriptorProvider