Linq Join 三表查询

最新推荐文章于 2025-03-09 18:34:37 发布

a12345_asdfg

最新推荐文章于 2025-03-09 18:34:37 发布

阅读量9.2k

点赞数

本文链接：https://blog.youkuaiyun.com/a12345_asdfg/article/details/21168495

版权

本文介绍如何使用SQL查询创建购物车视图，根据不同类型的商品进行数据聚合，包括商品详细信息和用户购物车信息的关联。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

   public static IQueryable<ShoppingCarView> CreateView(int type)
        {
            var context = new RookieFContext(AtawAppContext.Current.DefaultConnString);
            IQueryable<ShoppingCarView> view;

             if (type == (int)RookieFShoppingCarType.RookieFMall)
             {
                 view = context.RF_TASHOPINGCAR.Join(context.RF_MALLGOODS,
                   a => a.RT_DISHESID, b => b.FID, (a, b) => new ShoppingCarView()
                   {
                       RF_TASHOPINGCAR = a,
                       RF_MALLGOODS = b

                   });
             }else
                 view = from o in context.RF_TASHOPINGCAR
                        join p in context.RF_TAMENU on o.RT_DISHESID equals p.FID into ords
                        join d in context.RF_TALOVEPROGRAM on o.RT_DISHESID equals d.FID into programs
                        select new ShoppingCarView()
                        {
                            RF_TASHOPINGCAR= o,
                            RF_TAMENU = ords.FirstOrDefault(),
                            RF_TALOVEPROGRAM = programs.FirstOrDefault()
                        };
            return view;
        }