Interface ISqlExpressionVisitor

Interface, which describe visitor for genereting sql select command.

Namespace: Kros.KORM.Query.Sql

Assembly: Kros.KORM.dll

Syntax

public interface ISqlExpressionVisitor

Methods

GenerateSql(Expression)

Generates the SQL from expression.

Declaration

QueryInfo GenerateSql(Expression expression)

Parameters

Type	Name	Description
System.Linq.Expressions.Expression	expression	The expression.

Returns

Type	Description
QueryInfo	SQL select command text.

GenerateWhereCondition(Expression, String)

Generate the SQL WHERE condition from whereExpression.

Declaration

WhereExpression GenerateWhereCondition(Expression whereExpression, string parameterNamePrefix = "")

Parameters

Type	Name	Description
System.Linq.Expressions.Expression	whereExpression	Where condition written by LINQ expression.
System.String	parameterNamePrefix	Prefix of parameter name.

Returns

Type	Description
WhereExpression	WhereExpression which contains generated SQL WHERE condition and parameters.

Remarks

SQL WHERE condition is generated without WHERE keyword.

VisitColumns(ColumnsExpression)

Visits the columns.

Declaration

Expression VisitColumns(ColumnsExpression columnExpression)

Parameters

Type	Name	Description
ColumnsExpression	columnExpression	The column expression.

Returns

Type	Description
System.Linq.Expressions.Expression	Expression

VisitGroupBy(GroupByExpression)

Visits the group by.

Declaration

Expression VisitGroupBy(GroupByExpression groupByExpression)

Parameters

Type	Name	Description
GroupByExpression	groupByExpression	The group by expression.

Returns

Type	Description
System.Linq.Expressions.Expression	Expression

VisitOrderBy(OrderByExpression)

Visits the order by.

Declaration

Expression VisitOrderBy(OrderByExpression orderByExpression)

Parameters

Type	Name	Description
OrderByExpression	orderByExpression	The order by expression.

Returns

Type	Description
System.Linq.Expressions.Expression	Expression

VisitSelect(SelectExpression)

Visits the select.

Declaration

Expression VisitSelect(SelectExpression selectExpression)

Parameters

Type	Name	Description
SelectExpression	selectExpression	The select expression.

Returns

Type	Description
System.Linq.Expressions.Expression	Expression

VisitSql(SqlExpression)

Visits the SQL.

Declaration

Expression VisitSql(SqlExpression sqlExpression)

Parameters

Type	Name	Description
SqlExpression	sqlExpression	The SQL expression.

Returns

Type	Description
System.Linq.Expressions.Expression	Expression

VisitTable(TableExpression)

Visits the table.

Declaration

Expression VisitTable(TableExpression tableExpression)

Parameters

Type	Name	Description
TableExpression	tableExpression	The table expression.

Returns

Type	Description
System.Linq.Expressions.Expression	Expression

VisitWhere(WhereExpression)

Visits the where.

Declaration

Expression VisitWhere(WhereExpression whereExpression)

Parameters

Type	Name	Description
WhereExpression	whereExpression	The where expression.

Returns

Type	Description
System.Linq.Expressions.Expression	Expression