Where()方法中[或]条件构造的SQL对应的where语句不对

[ecocom]

代码：

string sql = fsql.Select<Entity>().Where(a => (a.Id > 0 && a.Id < 3) || (a.Name.Contains("aa") && a.Name.Contains("bb"))).ToSql();

生成的 where 为：

WHERE ((a."Id" > 0 AND a."Id" < 3 OR (a."Name") LIKE '%aa%' AND (a."Name") LIKE '%bb%'))

也尝试了用 LambadaExpressionExtensions 中的扩展来构造exp，生成的也是上边的 where：

Expression<Func<Entity, bool>> exp1 = a => a.Id > 0 && a.Id < 3;
Expression<Func<Entity, bool>> exp2 = a => a.Name.Contains("aa") && a.Name.Contains("bb");
Expression<Func<Entity, bool>> exp = exp1.Or(exp2);
string sql = fsql.Select<Entity>().Where(exp).ToSql();

正确的 where 应该是：

WHERE ((a."Id" > 0 AND a."Id" < 3) OR ((a."Name") LIKE '%aa%' AND (a."Name") LIKE '%bb%'))

[luoyunchong]

SQL 中 AND 优先级大于OR ，问题就不存在，这是优化后的结果

https://learn.microsoft.com/zh-cn/sql/t-sql/language-elements/operator-precedence-transact-sql?view=sql-server-ver15

[ecocom]

好的，谢谢