public IDbCommand Process(QueryTree.Expression expression, IEnumerable <QueryTree.ConstantExpression> parameters, IMascisSession session)
{
var queryText = ParseExpression(expression);
var command = new SqlCommand(queryText)
{
CommandType = CommandType.Text
};
foreach (var parameter in parameters)
{
command.Parameters.Add(new SqlParameter
{
Value = parameter.Value,
ParameterName = parameter.ParameterName
});
}
return(command);
}
public string ParseExpression(QueryTree.Expression expression)
{
return(ParseExpression(expression as QueryTree.FunctionExpression));
}
public string ParseExpression(QueryTree.Expression expression)
{
return(ParseExpression(expression as QueryTree.ConstantExpression));
}
public string ParseExpression(QueryTree.Expression expression)
{
return(ParseExpression(expression as QueryTree.AliasedExpression));
}
public string ParseExpression(QueryTree.Expression expression)
{
var parser = _parsers[expression.GetType()];
return(parser.ParseExpression(expression));
}
public string ParseExpression(QueryTree.Expression expression)
{
return(ParseExpression(expression as QueryTree.SelectExpression));
}
public string ParseExpression(QueryTree.Expression expression)
{
return(ParseExpression(expression as QueryTree.ValueGroupExpression));
}
public string ParseExpression(QueryTree.Expression expression)
{
return(ParseExpression(expression as QueryTree.BinaryExpression));
}
