C# Class DbExpressions.SqlQueryTranslator

Translates a DbExpression into a SQL Server specific string representation.

Inheritance: DbQueryTranslator

显示文件 Open project: seesharper/DbExpressions

Public Methods

Method	Description
SqlQueryTranslator ( System.Data.Common.DbProviderFactory providerFactory ) : System	Initializes a new instance of the SqlQueryTranslator class.

Protected Methods

Method	Description
CreateDefaultFunctionSyntax ( string functionBody, IEnumerable arguments ) : DbSqlExpression	Creates the default syntax for calling the function identified by functionBody
GetAggregateFunctionBody ( DbAggregateFunctionExpressionType aggregateFunctionExpressionType ) : string	Gets the textual representation of the aggregateFunctionExpressionType
GetBinaryOperator ( DbBinaryExpressionType binaryExpressionType ) : string	Gets the textual representation of the binaryExpressionType
GetMathematicalFunctionBody ( DbMathematicalFunctionExpressionType mathematicalFunctionExpressionType ) : string	Returns the name of the function as it is defined in the target DBMS.
GetStringFunctionBody ( DbStringFunctionExpressionType stringFunctionExpressionType ) : string	Returns the name of the function as it is defined in the target DBMS.
VisitAggregateFunctionExpression ( DbAggregateFunctionExpression aggregateFunctionExpression ) : DbExpression	Translates the aggregateFunctionExpression into a string representation.
VisitAliasExpression ( DbAliasExpression aliasExpression ) : DbExpression	Translates the aliasExpression into a string representation.
VisitBatchExpression ( DbBatchExpression batchExpression ) : DbExpression	Translates the batchExpression into a string representation.
VisitBinaryExpression ( DbBinaryExpression binaryExpression ) : DbExpression	Translates the binaryExpression into a string representation.
VisitColumnExpression ( DbColumnExpression columnExpression ) : DbExpression	Translates the columnExpression into a string representation.
VisitConcatExpression ( DbConcatExpression concatExpression ) : DbExpression	Translates the concatExpression into a string representation.
VisitConditionalExpression ( DbConditionalExpression conditionalExpression ) : DbExpression	Translates the conditionalExpression into a string representation.
VisitConstantExpression ( DbConstantExpression constantExpression ) : DbExpression	Translates the constantExpression into a string representation.
VisitDateTimeFunctionExpression ( DbDateTimeFunctionExpression dateTimeFunctionExpression ) : DbExpression	Translates the dateTimeFunctionExpression into a string representation.
VisitDeleteExpression ( DbDeleteExpression deleteExpression ) : DbExpression	Translates the deleteExpression into a string representation.
VisitExistsExpression ( DbExistsExpression existsExpression ) : DbExpression	Translates the existsExpression into a string representation.
VisitInExpression ( DbInExpression inExpression ) : DbExpression	Translates the inExpression into a string representation.
VisitInsertExpression ( DbInsertExpression insertExpression ) : DbExpression	Translates the insertExpression into a string representation.
VisitJoinExpression ( DbJoinExpression joinExpression ) : DbExpression	Translates the joinExpression into a string representation.
VisitListExpression ( DbListExpression listExpression ) : DbExpression	Translates the listExpression into a string representation.
VisitMathematicalFunctionExpression ( DbMathematicalFunctionExpression mathematicalFunctionExpression ) : DbExpression	Translates the mathematicalFunctionExpression into a string representation.
VisitOrderByExpression ( DbOrderByExpression orderByExpression ) : DbExpression	Translates the orderByExpression into a string representation.
VisitPrefixExpression ( DbPrefixExpression prefixExpression ) : DbExpression	Translates the prefixExpression into a string representation.
VisitSelectExpression ( DbSelectExpression selectExpression ) : DbExpression	Translates the selectExpression into a string representation.
VisitStringFunctionExpression ( DbStringFunctionExpression stringFunctionExpression ) : DbExpression	Translates the stringFunctionExpression into a string representation.
VisitTableExpression ( DbTableExpression tableExpression ) : DbExpression	Translates the tableExpression into a string representation.
VisitUnaryExpression ( DbUnaryExpression unaryExpression ) : DbExpression	Translates the unaryExpression into a string representation.
VisitUpdateExpression ( DbUpdateExpression updateExpression ) : DbExpression	Translates the updateExpression into a string representation.

Private Methods

Method	Description
BuildPagingStatement ( DbSelectExpression selectExpression ) : DbExpression
GetCastFunctionBody ( Type type ) : string
GetDateTimeFunctionBody ( DbDateTimeFunctionExpressionType dateTimeFunctionExpressionType ) : string

Method Details

CreateDefaultFunctionSyntax() protected method

Creates the default syntax for calling the function identified by functionBody

protected CreateDefaultFunctionSyntax ( string functionBody, IEnumerable arguments ) : DbSqlExpression
functionBody	string	The function body without the actual arguments
arguments	IEnumerable	A list of instances representing the function arguments.
return	DbSqlExpression

GetAggregateFunctionBody() protected method

Gets the textual representation of the aggregateFunctionExpressionType

protected GetAggregateFunctionBody ( DbAggregateFunctionExpressionType aggregateFunctionExpressionType ) : string
aggregateFunctionExpressionType	DbAggregateFunctionExpressionType	The for which to return the textual representation.
return	string

GetBinaryOperator() protected method

Gets the textual representation of the binaryExpressionType

protected GetBinaryOperator ( DbBinaryExpressionType binaryExpressionType ) : string
binaryExpressionType	DbBinaryExpressionType	The for which to return the textual representation.
return	string

GetMathematicalFunctionBody() protected method

Returns the name of the function as it is defined in the target DBMS.

protected GetMathematicalFunctionBody ( DbMathematicalFunctionExpressionType mathematicalFunctionExpressionType ) : string
mathematicalFunctionExpressionType	DbMathematicalFunctionExpressionType	The that specifies the function name to return.
return	string

GetStringFunctionBody() protected method

Returns the name of the function as it is defined in the target DBMS.

protected GetStringFunctionBody ( DbStringFunctionExpressionType stringFunctionExpressionType ) : string
stringFunctionExpressionType	DbStringFunctionExpressionType	The that specifies the function name to return.
return	string

SqlQueryTranslator() public method

Initializes a new instance of the SqlQueryTranslator class.

public SqlQueryTranslator ( System.Data.Common.DbProviderFactory providerFactory ) : System
providerFactory	System.Data.Common.DbProviderFactory	The that corresponds to this provider.
return	System

VisitAggregateFunctionExpression() protected method

Translates the aggregateFunctionExpression into a string representation.

protected VisitAggregateFunctionExpression ( DbAggregateFunctionExpression aggregateFunctionExpression ) : DbExpression
aggregateFunctionExpression	DbAggregateFunctionExpression	The to translate.
return	DbExpression

VisitAliasExpression() protected method

Translates the aliasExpression into a string representation.

protected VisitAliasExpression ( DbAliasExpression aliasExpression ) : DbExpression
aliasExpression	DbAliasExpression	The to translate.
return	DbExpression

VisitBatchExpression() protected method

Translates the batchExpression into a string representation.

protected VisitBatchExpression ( DbBatchExpression batchExpression ) : DbExpression
batchExpression	DbBatchExpression	The to translate.
return	DbExpression

VisitBinaryExpression() protected method

Translates the binaryExpression into a string representation.

protected VisitBinaryExpression ( DbBinaryExpression binaryExpression ) : DbExpression
binaryExpression	DbBinaryExpression	The to translate.
return	DbExpression

VisitColumnExpression() protected method

Translates the columnExpression into a string representation.

protected VisitColumnExpression ( DbColumnExpression columnExpression ) : DbExpression
columnExpression	DbColumnExpression	The to translate.
return	DbExpression

VisitConcatExpression() protected method

Translates the concatExpression into a string representation.

protected VisitConcatExpression ( DbConcatExpression concatExpression ) : DbExpression
concatExpression	DbConcatExpression	The to translate.
return	DbExpression

VisitConditionalExpression() protected method

Translates the conditionalExpression into a string representation.

protected VisitConditionalExpression ( DbConditionalExpression conditionalExpression ) : DbExpression
conditionalExpression	DbConditionalExpression	The to translate.
return	DbExpression

VisitConstantExpression() protected method

Translates the constantExpression into a string representation.

protected VisitConstantExpression ( DbConstantExpression constantExpression ) : DbExpression
constantExpression	DbConstantExpression	The to translate.
return	DbExpression

VisitDateTimeFunctionExpression() protected method

Translates the dateTimeFunctionExpression into a string representation.

protected VisitDateTimeFunctionExpression ( DbDateTimeFunctionExpression dateTimeFunctionExpression ) : DbExpression
dateTimeFunctionExpression	DbDateTimeFunctionExpression	The to translate.
return	DbExpression

VisitDeleteExpression() protected method

Translates the deleteExpression into a string representation.

protected VisitDeleteExpression ( DbDeleteExpression deleteExpression ) : DbExpression
deleteExpression	DbDeleteExpression	The to translate.
return	DbExpression

VisitExistsExpression() protected method

Translates the existsExpression into a string representation.

protected VisitExistsExpression ( DbExistsExpression existsExpression ) : DbExpression
existsExpression	DbExistsExpression	The to translate.
return	DbExpression

VisitInExpression() protected method

Translates the inExpression into a string representation.

protected VisitInExpression ( DbInExpression inExpression ) : DbExpression
inExpression	DbInExpression	The to translate.
return	DbExpression

VisitInsertExpression() protected method

Translates the insertExpression into a string representation.

protected VisitInsertExpression ( DbInsertExpression insertExpression ) : DbExpression
insertExpression	DbInsertExpression	The to translate.
return	DbExpression

VisitJoinExpression() protected method

Translates the joinExpression into a string representation.

protected VisitJoinExpression ( DbJoinExpression joinExpression ) : DbExpression
joinExpression	DbJoinExpression	The to translate.
return	DbExpression

VisitListExpression() protected method

Translates the listExpression into a string representation.

protected VisitListExpression ( DbListExpression listExpression ) : DbExpression
listExpression	DbListExpression	The to translate.
return	DbExpression

VisitMathematicalFunctionExpression() protected method

Translates the mathematicalFunctionExpression into a string representation.

protected VisitMathematicalFunctionExpression ( DbMathematicalFunctionExpression mathematicalFunctionExpression ) : DbExpression
mathematicalFunctionExpression	DbMathematicalFunctionExpression	The to translate.
return	DbExpression

VisitOrderByExpression() protected method

Translates the orderByExpression into a string representation.

protected VisitOrderByExpression ( DbOrderByExpression orderByExpression ) : DbExpression
orderByExpression	DbOrderByExpression	The to translate.
return	DbExpression

VisitPrefixExpression() protected method

Translates the prefixExpression into a string representation.

protected VisitPrefixExpression ( DbPrefixExpression prefixExpression ) : DbExpression
prefixExpression	DbPrefixExpression	The to translate.
return	DbExpression

VisitSelectExpression() protected method

Translates the selectExpression into a string representation.

protected VisitSelectExpression ( DbSelectExpression selectExpression ) : DbExpression
selectExpression	DbSelectExpression	The to translate.
return	DbExpression

VisitStringFunctionExpression() protected method

Translates the stringFunctionExpression into a string representation.

protected VisitStringFunctionExpression ( DbStringFunctionExpression stringFunctionExpression ) : DbExpression
stringFunctionExpression	DbStringFunctionExpression	The to translate.
return	DbExpression

VisitTableExpression() protected method

Translates the tableExpression into a string representation.

protected VisitTableExpression ( DbTableExpression tableExpression ) : DbExpression
tableExpression	DbTableExpression	The to translate.
return	DbExpression

VisitUnaryExpression() protected method

Translates the unaryExpression into a string representation.

protected VisitUnaryExpression ( DbUnaryExpression unaryExpression ) : DbExpression
unaryExpression	DbUnaryExpression	The to translate.
return	DbExpression

VisitUpdateExpression() protected method

Translates the updateExpression into a string representation.

protected VisitUpdateExpression ( DbUpdateExpression updateExpression ) : DbExpression
updateExpression	DbUpdateExpression	The to translate.
return	DbExpression