SqlFunc.Between生成的sql语句有问题 返回
魔术师 发布于2019/2/19
var query = db.Queryable<Member>()
.Where(mb =>SqlFunc.Between(mb.CreateTime.Year, DateTime.Now.Year-5, DateTime.Now.Year))
.ToList();
生成的sql语句为：
SELECT [Name],[MemberNO],[Avatar],[TypeId],[RegisterChannel],[Email],[Job],[Telphone],[Mobile],[MobileValid],[Nation],[Post],[QQ],[WX],[WXValid],[Sex],[Birthday],[CardType],[CertificateNO],[InviteCode],[InviteName],[MyInviteCode],[Grade],[UpdateTime],[CreateTime],[RegisterTime],[WorkUnit],[ProvinceId],[CityId],[DistrictId],[Address],[ShopId],[UsableIntegral],[CumulativeIntegral],[Balance],[Empirical],[Consumption],[Statu],[SortCode],[IsDel],[Id] FROM [mb_Member] WHERE DateName(Year,[CreateTime]) @constant4 (Result BETWEEN (@constant1- @Year3 ) AND Result)
{"@constant1":2019,"@Year3":5,"@constant4":2019}
热忱回答（3）
-
fate stay night VIP0
2019/2/21先提成变量解决 DateTime.Now.Year-5
0 回复 -
fate stay night VIP0
2019/2/21
后续修复这个BUG
0 回复 -
魔术师 VIP0
2019/2/28
@fate stay night：好的谢谢
0 回复