C# Класс DbExpressions.OracleQueryTranslator

Translates a DbExpression into a Oracle specific string representation.

Наследование: DbQueryTranslator

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

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

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

Метод	Описание
AddRowNumWhereClause ( DbExpression dbExpression ) : DbExpression
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

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

Initializes a new instance of the MySqlQueryTranslator class.

public OracleQueryTranslator ( 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