本功能类库主要提供给代码中使用Lambda表达式,后需转成SQL的条件语句这一需求
1、本类库不能解析Linq语句
2、不能解析SQL中的Select部分
class A
{
public Int16 Id { get; set; }
public string name { get; set; }
public string sex { get; set; }
}
AtkExpConditions<A> expa = new AtkExpConditions<A>();
expa.AddAndWhere(s => s.Id == 123 && s.name.Contains("a"), AtkAlias.a2);
expa.UpdateFields(s => new { s.Id, s.sex }, AtkAlias.a2);
结果生成下列两个语句:
1、Where (([a2].[Id] = 123) and ([a2].[name] LIKE '%' + 'a' + '%'))
2、[a2].[Id] = @Id,[a2].[sexA] = @sex
// 当需要多子句拼接时,自动合并成合适的子句,如 Where ,不会出现多个“where”关键词。
// When multiple clauses are required to be spliced,
// they are automatically merged into appropriate clauses,
// such as Where, without multiple "Where" keywords.
AtkExpConditions<A> expa2 = new AtkExpConditions<A>();
if (1==1)
{
expa2.AddAndWhere(s => s.Id == 123);
}
if (2==2)
{
expa2.AddAndWhere(s => s.name.Contains("a"));
}
结果生成下列两个语句:
Where ([a0].[Id] = 123) And ([a0].[name] LIKE '%' + 'a' + '%')
QQ:344709752