Linq : filter duplicated line without taking account a column

Question

I'm trying to remove from a datatable the duplicated lines, but without taking into account a column into the duplication filter.

Example :

| Name | Region |
| Toto |   5    |
| Toto |   2    |
| Toto |   1    |
| Gege |   2    |

What I'm searching for if to filter it as the following

| Name | Region |
| Toto |   5    |
| Gege |   2    |

Thank for your help.

var result = query.GroupBy(x => x.Name) .Select(group => group.First()); — MMK, Dec 29 '16 at 15:25
Can i suggest you a integration of distinct called DistinctBy? https://www.nuget.org/packages/MoreLinq.Source.MoreEnumerable.DistinctBy/ — federico scamuzzi, Dec 29 '16 at 15:27
you can use MoreLinq like so: var result = query.AsEnumerable() .DistinctBy(x => x.Name); — MMK, Dec 29 '16 at 15:27

score 0 · Answer 1 · answered Dec 29 '16 at 15:25

Try this

var filteredData = data.GroupBy( d=> d.Name).SelectMany(grouping => grouping.First());

Depending upon LinqProvider for the database (IQueryable implementation), The query may run on database, or on client side( if so, there will be memory/network bandwidth issues).

In some case, not all Linq constructs are supported.

score 0 · Answer 2 · answered Dec 29 '16 at 15:26

0

Try:

datatable.GroupBy(x => x.Name);

you need to add a using for the System.Linq namespace.

answered Dec 29 '16 at 15:26

Tha'er AlAjlouni ثائر العجلوني

14,069
7
33
38

Linq : filter duplicated line without taking account a column

2 Answers2