Question

I m using EF and LINQ. I have the following in my db table

branchId      Name        ItemId          CategoryId
2             Test1       1               1
5             Test1       1               1
3             Test1       1               2
2             Test2       2               1
7             Test2       2               1

我需要按项目Id和分行分类,因此产出应当被忽视。

Name  ItemId  CategoryId
Test1 1       1
Test1 1       2
Test2 2       2

请提供帮助。感谢

Answer 1

您需要申请多个栏目中的组别,以便你们需要按下文按多个栏目分类的代码。

var numberGroups = from it in context.items
                   group it by new { it.ItemId,it.Name,it.CateogryID } into g
                   select new { ItemID = g.Key.ItemID, Name= g.Key.Name
                                CategoryID = g.Key.CategoryID };

Answer 2

var query = from item in context.Item
            group by item.Name,ItemId,item.CategoryId
           select item.Name,Item.Id,item.CategoryId;

友情链接