public override string GetSql(ISqlGenerationContext context, IDictionary <string, object> parameters)
{
var classMap = context.ClassMap;
var columnName = classMap.GetColumnName(context.Dialect, PropertyName);
var columnName2 = classMap.GetColumnName(context.Dialect, PropertyName2);
return($"({columnName} {GetOperatorString()} {columnName2})");
}
public string GetSql(ISqlGenerationContext context, IDictionary <string, object> parameters)
{
var classMap = context.ClassMap;
var sql = new StringBuilder();
sql.Append(Not ? "NOT " : string.Empty)
.Append("EXISTS (SELECT 1 FROM ")
.Append(classMap.GetTableName(context.Dialect))
.Append(" WHERE ")
.Append(Predicate.GetSql(context, parameters))
.Append("))");
return(sql.ToString());
}
public override string GetSql(ISqlGenerationContext context, IDictionary <string, object> parameters)
{
var columnName = context.ClassMap.GetColumnName(context.Dialect, PropertyName);
var @params = new List <string>();
foreach (var item in Collection)
{
@params.Add(parameters.SetParameterName(PropertyName, item, context.Dialect.ParameterPrefix));
}
var commaDelimited = string.Join(",", @params);
return($@"({columnName} {GetIsNotStatement(Not)} IN ({commaDelimited}))");
}
public string GetSql(ISqlGenerationContext context, IDictionary <string, object> parameters)
{
var seperator = Operator == GroupOperator.And ? " AND " : " OR ";
return("(" + Predicates.Aggregate(new StringBuilder(),
(sb, p) => (sb.Length == 0 ? sb : sb.Append(seperator)).Append(p.GetSql(context, parameters)),
sb =>
{
var s = sb.ToString();
if (s.Length == 0)
{
return context.Dialect.EmptyExpression;
}
return s;
}
) + ")");
}
public override string GetSql(ISqlGenerationContext context, IDictionary <string, object> parameters)
{
var classMap = context.ClassMap;
var columnName = classMap.GetColumnName(context.Dialect, PropertyName);
if (Value == null)
{
return(GetSqlForNull(columnName));
}
if (Value is IEnumerable && !(Value is string))
{
return(GetSqlForEnumerable(columnName, parameters, context.Dialect));
}
return(GetSqlFromSingleStringField(columnName, parameters, context.Dialect));
}
public override string GetSql(ISqlGenerationContext context, IDictionary <string, object> parameters)
{
var classMap = context.ClassMap;
var columnName = classMap.GetColumnName(context.Dialect, PropertyName);
var propertyName1 = parameters.SetParameterName(PropertyName, Value.Value1, context.Dialect.ParameterPrefix);
var propertyName2 = parameters.SetParameterName(PropertyName, Value.Value2, context.Dialect.ParameterPrefix);
var sb = new StringBuilder();
sb.Append(columnName)
.Append(" ")
.Append(Not ? "NOT " : string.Empty)
.Append("BETWEEN ")
.Append(propertyName1)
.Append(" AND ")
.Append(propertyName2);
return(sb.ToString());
}
public abstract string GetSql(ISqlGenerationContext context, IDictionary <string, object> parameters);
