public virtual string GenerateSql(SelectExpression selectExpression)
{
Check.NotNull(selectExpression, "selectExpression");
_sql = new IndentedStringBuilder();
_parameters = new List <CommandParameter>();
selectExpression.Accept(this);
return(_sql.ToString());
}
public virtual string GenerateSql(SelectExpression expression)
{
Check.NotNull(expression, "expression");
_sql = new StringBuilder();
_parameters = new List <CommandParameter>();
_aliasCount = 0;
expression.Accept(this);
return(_sql.ToString());
}
public virtual string GenerateSql(
SelectExpression selectExpression, IDictionary <string, object> parameterValues)
{
Check.NotNull(selectExpression, nameof(selectExpression));
Check.NotNull(parameterValues, nameof(parameterValues));
_sql = new IndentedStringBuilder();
_parameters = new List <string>();
_parameterValues = parameterValues;
selectExpression.Accept(this);
return(_sql.ToString());
}
public virtual TableQuery GenerateTableQuery([NotNull] SelectExpression selectExpression)
{
Check.NotNull(selectExpression, "selectExpression");
_whereStringBuilder = new StringBuilder();
_take = null;
selectExpression.Accept(this);
var tableQuery = new TableQuery();
tableQuery.Where(_whereStringBuilder.ToString());
tableQuery.Take(_take);
return(tableQuery);
}
