linq to sql　左联接出错，未将对象引用设置到实例

最新推荐文章于 2021-01-02 12:58:38 发布

weixin_30275415

最新推荐文章于 2021-01-02 12:58:38 发布

阅读量120

点赞数

原文链接：http://www.cnblogs.com/jys509/p/3576406.html

版权

            var result = from a in model
                         join b in orderDetailModel on a.FoodMenuID equals b.FoodMenuID into g
                         from b in g.DefaultIfEmpty()
                         select new Model.WebApiModel.WMFoodMenu
                         {
                             BarginPrice = a.BarginPrice,
                             Credits = a.Credits,
                             FoodMenuCategoryID = a.FoodMenuCategoryID,
                             FoodMenuID = a.FoodMenuID,
                             RestaurantID = a.RestaurantID,
                             FoodMenuName = a.FoodMenuName,
                             SaleCount = b != null ? b.FoodMenuSaleCount : 0,
                             ImgUrl100 = a.ImgUrl100,
                             ImgUrl150 = a.ImgUrl150,
                             IsRecommend = a.IsRecommend,
                             Price = a.Price
                         };

这里，必须要注意一点是：SaleCount = b != null ? b.FoodMenuSaleCount : 0，这里如果SaleCount字段不允许为空，必须先判定。

如果写成　SaleCount = b.FoodMenuSaleCount，当右边数据为空时，将出现未将对象引用设置对实例的错误

转载于:https://www.cnblogs.com/jys509/p/3576406.html