C# Class DbExpressions.SQLiteQueryTranslator

Translates a DbExpression into a SqlLite specific string representation.
Inheritance: DbQueryTranslator
Datei anzeigen Open project: seesharper/DbExpressions

Public Methods

Method Description
SQLiteQueryTranslator ( System.Data.Common.DbProviderFactory providerFactory ) : System

Initializes a new instance of the SQLiteQueryTranslator 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
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

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

SQLiteQueryTranslator() public method

Initializes a new instance of the SQLiteQueryTranslator class.
public SQLiteQueryTranslator ( 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