C# Класс DbExpressions.MySqlQueryTranslator

Translates a DbExpression into a MySql specific string representation.
DayOfWeek MilliSeconds
Наследование: DbQueryTranslator
Показать файл Открыть проект

Открытые методы

Метод Описание
MySqlQueryTranslator ( System.Data.Common.DbProviderFactory providerFactory ) : System

Initializes a new instance of the MySqlQueryTranslator class.
Translate ( DbExpression dbExpression ) : DbTranslateResult

Защищенные методы

Метод Описание
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.

Приватные методы

Метод Описание
ContainsSkip ( DbSelectExpression selectExpression ) : bool
ContainsSkipAndTake ( DbSelectExpression selectExpression ) : bool
ContainsTake ( DbSelectExpression selectExpression ) : bool
CreateDefaultDateTimeFunctionSyntax ( string functionBody, IEnumerable arguments ) : DbSqlExpression

Creates the default syntax for calling the datetime function identified by functionBody
GetCastFunctionBody ( Type type ) : string
GetDateTimeFunctionBody ( DbDateTimeFunctionExpressionType dateTimeFunctionExpressionType ) : string
ReplaceSquareWithPower ( DbExpression dbExpression ) : DbExpression

Описание методов

CreateDefaultFunctionSyntax() защищенный Метод

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.
Результат DbSqlExpression

GetAggregateFunctionBody() защищенный Метод

Gets the textual representation of the aggregateFunctionExpressionType
protected GetAggregateFunctionBody ( DbAggregateFunctionExpressionType aggregateFunctionExpressionType ) : string
aggregateFunctionExpressionType DbAggregateFunctionExpressionType The for which to return the textual representation.
Результат string

GetBinaryOperator() защищенный Метод

Gets the textual representation of the binaryExpressionType
protected GetBinaryOperator ( DbBinaryExpressionType binaryExpressionType ) : string
binaryExpressionType DbBinaryExpressionType The for which to return the textual representation.
Результат string

GetMathematicalFunctionBody() защищенный Метод

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.
Результат string

GetStringFunctionBody() защищенный Метод

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.
Результат string

MySqlQueryTranslator() публичный Метод

Initializes a new instance of the MySqlQueryTranslator class.
public MySqlQueryTranslator ( System.Data.Common.DbProviderFactory providerFactory ) : System
providerFactory System.Data.Common.DbProviderFactory The that corresponds to this provider.
Результат System

Translate() публичный Метод

public Translate ( DbExpression dbExpression ) : DbTranslateResult
dbExpression DbExpression
Результат DbTranslateResult

VisitAggregateFunctionExpression() защищенный Метод

Translates the aggregateFunctionExpression into a string representation.
protected VisitAggregateFunctionExpression ( DbAggregateFunctionExpression aggregateFunctionExpression ) : DbExpression
aggregateFunctionExpression DbAggregateFunctionExpression The to translate.
Результат DbExpression

VisitAliasExpression() защищенный Метод

Translates the aliasExpression into a string representation.
protected VisitAliasExpression ( DbAliasExpression aliasExpression ) : DbExpression
aliasExpression DbAliasExpression The to translate.
Результат DbExpression

VisitBatchExpression() защищенный Метод

Translates the batchExpression into a string representation.
protected VisitBatchExpression ( DbBatchExpression batchExpression ) : DbExpression
batchExpression DbBatchExpression The to translate.
Результат DbExpression

VisitBinaryExpression() защищенный Метод

Translates the binaryExpression into a string representation.
protected VisitBinaryExpression ( DbBinaryExpression binaryExpression ) : DbExpression
binaryExpression DbBinaryExpression The to translate.
Результат DbExpression

VisitColumnExpression() защищенный Метод

Translates the columnExpression into a string representation.
protected VisitColumnExpression ( DbColumnExpression columnExpression ) : DbExpression
columnExpression DbColumnExpression The to translate.
Результат DbExpression

VisitConcatExpression() защищенный Метод

Translates the concatExpression into a string representation.
protected VisitConcatExpression ( DbConcatExpression concatExpression ) : DbExpression
concatExpression DbConcatExpression The to translate.
Результат DbExpression

VisitConditionalExpression() защищенный Метод

Translates the conditionalExpression into a string representation.
protected VisitConditionalExpression ( DbConditionalExpression conditionalExpression ) : DbExpression
conditionalExpression DbConditionalExpression The to translate.
Результат DbExpression

VisitConstantExpression() защищенный Метод

Translates the constantExpression into a string representation.
protected VisitConstantExpression ( DbConstantExpression constantExpression ) : DbExpression
constantExpression DbConstantExpression The to translate.
Результат DbExpression

VisitDateTimeFunctionExpression() защищенный Метод

Translates the dateTimeFunctionExpression into a string representation.
protected VisitDateTimeFunctionExpression ( DbDateTimeFunctionExpression dateTimeFunctionExpression ) : DbExpression
dateTimeFunctionExpression DbDateTimeFunctionExpression The to translate.
Результат DbExpression

VisitDeleteExpression() защищенный Метод

Translates the deleteExpression into a string representation.
protected VisitDeleteExpression ( DbDeleteExpression deleteExpression ) : DbExpression
deleteExpression DbDeleteExpression The to translate.
Результат DbExpression

VisitExistsExpression() защищенный Метод

Translates the existsExpression into a string representation.
protected VisitExistsExpression ( DbExistsExpression existsExpression ) : DbExpression
existsExpression DbExistsExpression The to translate.
Результат DbExpression

VisitInExpression() защищенный Метод

Translates the inExpression into a string representation.
protected VisitInExpression ( DbInExpression inExpression ) : DbExpression
inExpression DbInExpression The to translate.
Результат DbExpression

VisitInsertExpression() защищенный Метод

Translates the insertExpression into a string representation.
protected VisitInsertExpression ( DbInsertExpression insertExpression ) : DbExpression
insertExpression DbInsertExpression The to translate.
Результат DbExpression

VisitJoinExpression() защищенный Метод

Translates the joinExpression into a string representation.
protected VisitJoinExpression ( DbJoinExpression joinExpression ) : DbExpression
joinExpression DbJoinExpression The to translate.
Результат DbExpression

VisitListExpression() защищенный Метод

Translates the listExpression into a string representation.
protected VisitListExpression ( DbListExpression listExpression ) : DbExpression
listExpression DbListExpression The to translate.
Результат DbExpression

VisitMathematicalFunctionExpression() защищенный Метод

Translates the mathematicalFunctionExpression into a string representation.
protected VisitMathematicalFunctionExpression ( DbMathematicalFunctionExpression mathematicalFunctionExpression ) : DbExpression
mathematicalFunctionExpression DbMathematicalFunctionExpression The to translate.
Результат DbExpression

VisitOrderByExpression() защищенный Метод

Translates the orderByExpression into a string representation.
protected VisitOrderByExpression ( DbOrderByExpression orderByExpression ) : DbExpression
orderByExpression DbOrderByExpression The to translate.
Результат DbExpression

VisitPrefixExpression() защищенный Метод

Translates the prefixExpression into a string representation.
protected VisitPrefixExpression ( DbPrefixExpression prefixExpression ) : DbExpression
prefixExpression DbPrefixExpression The to translate.
Результат DbExpression

VisitSelectExpression() защищенный Метод

Translates the selectExpression into a string representation.
protected VisitSelectExpression ( DbSelectExpression selectExpression ) : DbExpression
selectExpression DbSelectExpression The to translate.
Результат DbExpression

VisitStringFunctionExpression() защищенный Метод

Translates the stringFunctionExpression into a string representation.
protected VisitStringFunctionExpression ( DbStringFunctionExpression stringFunctionExpression ) : DbExpression
stringFunctionExpression DbStringFunctionExpression The to translate.
Результат DbExpression

VisitTableExpression() защищенный Метод

Translates the tableExpression into a string representation.
protected VisitTableExpression ( DbTableExpression tableExpression ) : DbExpression
tableExpression DbTableExpression The to translate.
Результат DbExpression

VisitUnaryExpression() защищенный Метод

Translates the unaryExpression into a string representation.
protected VisitUnaryExpression ( DbUnaryExpression unaryExpression ) : DbExpression
unaryExpression DbUnaryExpression The to translate.
Результат DbExpression

VisitUpdateExpression() защищенный Метод

Translates the updateExpression into a string representation.
protected VisitUpdateExpression ( DbUpdateExpression updateExpression ) : DbExpression
updateExpression DbUpdateExpression The to translate.
Результат DbExpression