C# Class DbExpressions.SqlQueryTranslator

Translates a DbExpression into a SQL Server specific string representation.
Inheritance: DbQueryTranslator
Afficher le fichier Open project: seesharper/DbExpressions

Méthodes publiques

Méthode Description
SqlQueryTranslator ( System.Data.Common.DbProviderFactory providerFactory ) : System

Initializes a new instance of the SqlQueryTranslator class.

Méthodes protégées

Méthode 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

Méthode Description
BuildPagingStatement ( DbSelectExpression selectExpression ) : DbExpression
GetCastFunctionBody ( Type type ) : string
GetDateTimeFunctionBody ( DbDateTimeFunctionExpressionType dateTimeFunctionExpressionType ) : string

Method Details

CreateDefaultFunctionSyntax() protected méthode

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.
Résultat DbSqlExpression

GetAggregateFunctionBody() protected méthode

Gets the textual representation of the aggregateFunctionExpressionType
protected GetAggregateFunctionBody ( DbAggregateFunctionExpressionType aggregateFunctionExpressionType ) : string
aggregateFunctionExpressionType DbAggregateFunctionExpressionType The for which to return the textual representation.
Résultat string

GetBinaryOperator() protected méthode

Gets the textual representation of the binaryExpressionType
protected GetBinaryOperator ( DbBinaryExpressionType binaryExpressionType ) : string
binaryExpressionType DbBinaryExpressionType The for which to return the textual representation.
Résultat string

GetMathematicalFunctionBody() protected méthode

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.
Résultat string

GetStringFunctionBody() protected méthode

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.
Résultat string

SqlQueryTranslator() public méthode

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.
Résultat System

VisitAggregateFunctionExpression() protected méthode

Translates the aggregateFunctionExpression into a string representation.
protected VisitAggregateFunctionExpression ( DbAggregateFunctionExpression aggregateFunctionExpression ) : DbExpression
aggregateFunctionExpression DbAggregateFunctionExpression The to translate.
Résultat DbExpression

VisitAliasExpression() protected méthode

Translates the aliasExpression into a string representation.
protected VisitAliasExpression ( DbAliasExpression aliasExpression ) : DbExpression
aliasExpression DbAliasExpression The to translate.
Résultat DbExpression

VisitBatchExpression() protected méthode

Translates the batchExpression into a string representation.
protected VisitBatchExpression ( DbBatchExpression batchExpression ) : DbExpression
batchExpression DbBatchExpression The to translate.
Résultat DbExpression

VisitBinaryExpression() protected méthode

Translates the binaryExpression into a string representation.
protected VisitBinaryExpression ( DbBinaryExpression binaryExpression ) : DbExpression
binaryExpression DbBinaryExpression The to translate.
Résultat DbExpression

VisitColumnExpression() protected méthode

Translates the columnExpression into a string representation.
protected VisitColumnExpression ( DbColumnExpression columnExpression ) : DbExpression
columnExpression DbColumnExpression The to translate.
Résultat DbExpression

VisitConcatExpression() protected méthode

Translates the concatExpression into a string representation.
protected VisitConcatExpression ( DbConcatExpression concatExpression ) : DbExpression
concatExpression DbConcatExpression The to translate.
Résultat DbExpression

VisitConditionalExpression() protected méthode

Translates the conditionalExpression into a string representation.
protected VisitConditionalExpression ( DbConditionalExpression conditionalExpression ) : DbExpression
conditionalExpression DbConditionalExpression The to translate.
Résultat DbExpression

VisitConstantExpression() protected méthode

Translates the constantExpression into a string representation.
protected VisitConstantExpression ( DbConstantExpression constantExpression ) : DbExpression
constantExpression DbConstantExpression The to translate.
Résultat DbExpression

VisitDateTimeFunctionExpression() protected méthode

Translates the dateTimeFunctionExpression into a string representation.
protected VisitDateTimeFunctionExpression ( DbDateTimeFunctionExpression dateTimeFunctionExpression ) : DbExpression
dateTimeFunctionExpression DbDateTimeFunctionExpression The to translate.
Résultat DbExpression

VisitDeleteExpression() protected méthode

Translates the deleteExpression into a string representation.
protected VisitDeleteExpression ( DbDeleteExpression deleteExpression ) : DbExpression
deleteExpression DbDeleteExpression The to translate.
Résultat DbExpression

VisitExistsExpression() protected méthode

Translates the existsExpression into a string representation.
protected VisitExistsExpression ( DbExistsExpression existsExpression ) : DbExpression
existsExpression DbExistsExpression The to translate.
Résultat DbExpression

VisitInExpression() protected méthode

Translates the inExpression into a string representation.
protected VisitInExpression ( DbInExpression inExpression ) : DbExpression
inExpression DbInExpression The to translate.
Résultat DbExpression

VisitInsertExpression() protected méthode

Translates the insertExpression into a string representation.
protected VisitInsertExpression ( DbInsertExpression insertExpression ) : DbExpression
insertExpression DbInsertExpression The to translate.
Résultat DbExpression

VisitJoinExpression() protected méthode

Translates the joinExpression into a string representation.
protected VisitJoinExpression ( DbJoinExpression joinExpression ) : DbExpression
joinExpression DbJoinExpression The to translate.
Résultat DbExpression

VisitListExpression() protected méthode

Translates the listExpression into a string representation.
protected VisitListExpression ( DbListExpression listExpression ) : DbExpression
listExpression DbListExpression The to translate.
Résultat DbExpression

VisitMathematicalFunctionExpression() protected méthode

Translates the mathematicalFunctionExpression into a string representation.
protected VisitMathematicalFunctionExpression ( DbMathematicalFunctionExpression mathematicalFunctionExpression ) : DbExpression
mathematicalFunctionExpression DbMathematicalFunctionExpression The to translate.
Résultat DbExpression

VisitOrderByExpression() protected méthode

Translates the orderByExpression into a string representation.
protected VisitOrderByExpression ( DbOrderByExpression orderByExpression ) : DbExpression
orderByExpression DbOrderByExpression The to translate.
Résultat DbExpression

VisitPrefixExpression() protected méthode

Translates the prefixExpression into a string representation.
protected VisitPrefixExpression ( DbPrefixExpression prefixExpression ) : DbExpression
prefixExpression DbPrefixExpression The to translate.
Résultat DbExpression

VisitSelectExpression() protected méthode

Translates the selectExpression into a string representation.
protected VisitSelectExpression ( DbSelectExpression selectExpression ) : DbExpression
selectExpression DbSelectExpression The to translate.
Résultat DbExpression

VisitStringFunctionExpression() protected méthode

Translates the stringFunctionExpression into a string representation.
protected VisitStringFunctionExpression ( DbStringFunctionExpression stringFunctionExpression ) : DbExpression
stringFunctionExpression DbStringFunctionExpression The to translate.
Résultat DbExpression

VisitTableExpression() protected méthode

Translates the tableExpression into a string representation.
protected VisitTableExpression ( DbTableExpression tableExpression ) : DbExpression
tableExpression DbTableExpression The to translate.
Résultat DbExpression

VisitUnaryExpression() protected méthode

Translates the unaryExpression into a string representation.
protected VisitUnaryExpression ( DbUnaryExpression unaryExpression ) : DbExpression
unaryExpression DbUnaryExpression The to translate.
Résultat DbExpression

VisitUpdateExpression() protected méthode

Translates the updateExpression into a string representation.
protected VisitUpdateExpression ( DbUpdateExpression updateExpression ) : DbExpression
updateExpression DbUpdateExpression The to translate.
Résultat DbExpression