报错不支持ToList()!怎么实现这种子查询? 返回

SqlSugar 老数据
2 2352
该叫什么 灰白 发布于2018/5/18
悬赏:0 飞吻
var list = db.DataBase
.Queryable<Store, StoreSelectGoods, Goods>((a, b, c) => a.Id == StoreId && b.StoreId == a.Id && c.Id == b.GoodsId)
.Select((a, b, c) => new ShowGoods() {
             BrandId = c.BrandId,
             CategoryId = c.CategoryId,
             Images = db.DataBase.Queryable<GoodsImg>().Where(d=>d.GoodsId==c.Id).Select(d=>new GoodsImg()).ToList(),
             CreateTime = c.CreateTime,
            ExpressAmount = c.ExpressAmount,
             ExpressRemak = c.ExpressRemak,
              GoodsNo = c.GoodsNo,
             GoodsStatus = c.GoodsStatus,
             Id = c.Id,
             Name = c.Name,
             PlatformId = c.PlatformId,
            Title = c.Title,
             Sale = db.Sale.GetSingle(d => d.GoodsId == c.Id),
              UploadTime = c.UploadTime,
             DefaultSku = db.DataBase.Queryable<GoodsSku>().OrderBy(d=>d.Sort,OrderByType.Asc).Take(1).ToList().SingleOrDefault()
            }).ToList();


blob.png

热忱回答2