finding duplicates for two columns entries in datatable using LINQ

Question

I have a datatable dt which has supplierId and SubsystemId as 2 of its columns . I want to find if there is any duplicate entries for the combination of these two column values .

I am a starter to Linq . How can I do this ?

pls show your tried code

cuongle
– cuongle

2012-10-18 05:45:56 +00:00
Commented Oct 18, 2012 at 5:45 — cuongle
– cuongle, Commented Oct 18, 2012 at 5:45

SRIRAM · Accepted Answer · 2012-10-18 05:47:20Z

6

You can find your duplicates by grouping your elements by supplierId and SubsystemId. Do a count on them afterwards and you will find which ones are duplicates.

This is how you would isolate the dupes :

  var duplicates = items.GroupBy(i => new {i.supplierId, i.SubsystemId})
                  .Where(g => g.Count() > 1)
                  .Select(g => g.Key);

answered Oct 18, 2012 at 5:47

SRIRAM

1,8982 gold badges17 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kuntady Nithesh · Accepted Answer · 2012-10-18 07:17:00Z

0

  var dups = from row in dt.Copy().AsEnumerable()
                       group row by new { SubsystemTypeId = row.Field<int>("SubsystemTypeId"), SupplierId = row.Field<int>("SupplierId") }
                           into grp
                           where grp.Count() > 1
                          select grp.Key;

Thanks SriRam

answered Oct 18, 2012 at 7:17

Kuntady Nithesh

11.8k20 gold badges65 silver badges88 bronze badges

Collectives™ on Stack Overflow

finding duplicates for two columns entries in datatable using LINQ

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related