Hints分页中count()未增加 返回
SqlSugar
沟通中
3
694
悬赏:0 飞吻
热忱回答(3)
-
fate sta VIP0
2025/12/28var totalCount = new RefAsync<int>(0); var query = _db.Queryable<TestOther>() .GroupBy(o => o.Age) .Select(o => new UserGroupResult { Age = o.Age, TotalCount = SqlFunc.AggregateCount(o.ID), LastTime = SqlFunc.AggregateMax(o.Time) }) .MergeTable()//少了这行 .OrderByDescending(r => r.TotalCount); await query .Hints("/* HintDemo2 */") .ToPageListAsync(pageIndex, pageSize, totalCount);0 回复 -
fate sta VIP0
2025/12/28.MergeTable()//少了这行0 回复 -
一会我就打哭 VIP0
2025/12/28搞定,也发现了Hints顺序得写前面。
0 回复
