SqlSugarRepository icon indicating copy to clipboard operation
SqlSugarRepository copied to clipboard

使用Where中有枚举变量的聚合函数(Count)查询时存在问题

Open JimmyiZhang opened this issue 7 years ago • 0 comments

RouteType为enum

view.RouteType = RouteType.Route;
db.Client.Queryable<RouteOrder>()
             .Where(r =>r.RouteType==view.RouteType)
             .Count();

生成的语句: SELECT COUNT(1) FROM [RouteOrder] WHERE 1=1 AND ([RouteType] = @RouteType101)
生成的参数: [{"key":"@RouteType101","value":"Route"}] *Where直接使用枚举(非变量)结果正确 生成的参数: [{"key":"@RouteType101","value":"1"}] *Select中无此问题

版本: SqlSugarRepositoryv2.1.3.0

JimmyiZhang avatar Jan 11 '17 02:01 JimmyiZhang