在后台用Lambda查实体的时候报的数据库错误,在网上找到这个解决方法https://www.cnblogs.com/jxldjsn/p/8108141.html;但是不适用我的场景。
问题
OrderParentService orderParentService = new OrderParentService();
OrderItemService orderItemService = new OrderItemService();
var platform = Platform.Amazon.ToString();
var datetime= DateTime.Now.AddMonths(-1);
//订单列表
var orderParentList = orderParentService.FindAll(p => p.PLATFORM == platform && p.ORDER_INSERT_DATE >= datetime).Select(p => p.ORDER_ID).Tolist();
//订单详情
var orderItemList = orderItemService.FindAll(p => orderParentList.Contains(p.ORDER_ID) && p.ASIN == null);
通过问同事最后发现是包含函数Contains的问题,当订单列表Tolist之后使用Contains会自动转换成In的查询方式,当ID超过两千条就会报错
解决
通过把两个实体放到同一个上下文
关键字 ObjContext
OrderParentService orderParentService = new OrderParentService();
var op = orderParentService.ObjContext;
OrderItemService orderItemService = new OrderItemService();
orderItemService.ObjContext = op;
var platform = Platform.Amazon.ToString();
var datetime= DateTime.Now.AddMonths(-1);
//订单列表
var orderParentList = orderParentService.FindAll(p => p.PLATFORM == platform && p.ORDER_INSERT_DATE >= datetime).Select(p => p.ORDER_ID);
//订单详情
var orderItemList = orderItemService.FindAll(p => orderParentList.Contains(p.ORDER_ID) && p.ASIN == null);
再多说一句:在linq中不能直接把时间拼上去!!!比如这种 一定会报错的!!!只能放变量,把时间放在语句外赋值(都是踩过的坑...)
var orderParentList = orderParentService.FindAll(p => p.PLATFORM == platform && p.ORDER_INSERT_DATE >= DateTime.Now.AddMonths(-1)).Select(p => p.ORDER_ID);