public IExecuteSql Where(Expression <Func <T, bool> > criteria) { _sb.RemoveLastIfEquals(','); _sb.Append($" where {_writer.GetSql(criteria)}"); return(this); }
private void Round(MethodCallExpression method, StringBuilder sb, IGenerateSqlFromExpressions writer) { sb.Append("round("); sb.Append(writer.GetColumnsSql(method.Arguments[1])); sb.Append(","); sb.Append(writer.GetSql(method.Arguments[2])); sb.Append(")"); }
IConnectWhere <T> IWhere <T> .Where(Expression <Func <T, bool> > criteria) { _sb.Append("where "); _sb.AppendLine(_writer.GetSql(criteria)); return(this); }
public void WriteCriteria(LambdaExpression expr) { _sb.Append(" where "); _sb.Append(_writer.GetSql(expr)); }
private void BetweenDates(MethodCallExpression arg1, StringBuilder sb, IGenerateSqlFromExpressions writer) { var date = writer.GetColumnsSql(arg1.Arguments[0]); sb.Append($"{date}>={writer.GetSql(arg1.Arguments[1])} and {date}<={writer.GetSql(arg1.Arguments[2])}"); }