Skip to content

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

@JimmyiZhang

Description

@JimmyiZhang

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions