C# LinqToExcel, Distinct showing all results - tried online solutions, couldn't solve

Question

  var ItemMaster = new ExcelQueryFactory("E:\\Group Item Master.xlsx");

        var ItemList = (from x in ItemMaster.Worksheet()
                        select new
                        {
                            CategoryName = x["CategoryName"],
                            GroupName = x["GroupName"],
                            ModelNo = x["ModelNo"],
                            Description = x["Description"],
                            Code = x["Code"]
                        }).ToList();


        var DistinctCategory = ItemList.Select(x => x.CategoryName).ToArray().Distinct();
        //shows categoryname repeated


        var iteml = ItemList.GroupBy(x => x.CategoryName);
        var DistinctCategoryTwo = iteml.Select(x => x.First()).ToList();
        //shows categoryname repeated

Are you sure that it's really repeated and not in different case or with extra space? — Alex Riabov, Jul 08 '18 at 16:14

Arun Prasad E S · Accepted Answer · 2018-07-09T01:55:45.467

2

Sorry guys, it was linqToExcel specific issue

 var CategoryList = ItemList.Select(x => x.CategoryName.Value).Distinct().ToList();

value column was needed to fix it

edited Jul 09 '18 at 01:55

answered Jul 08 '18 at 16:27

Arun Prasad E S

9,489
8
74
87

1

You don't need that `ToList` before the `Distinct` – juharr Jul 08 '18 at 18:35

C# LinqToExcel, Distinct showing all results - tried online solutions, couldn't solve

1 Answers1