Get all DISTINCT items in the List with LINQ

Question

I am quite new to LINQ, I have the following script which returns me the first item in the table if condition meets, however, I would like to get all distinct items not only the first one. I am relatively new on this platform.

public LG GetLG (int WID)
{
    lock (locker) {
      return database.Table<LG> ().FirstOrDefault (x => x.id == WID);
    }
}

http://stackoverflow.com/questions/489258/linq-distinct-on-a-particular-property/491832#491832 — user1666620, Dec 08 '15 at 15:44
Possible duplicate of [Get distinct values from list](http://stackoverflow.com/questions/15086438/get-distinct-values-from-list) — MakePeaceGreatAgain, Dec 08 '15 at 15:46

Alex · Accepted Answer · 2015-12-08T16:41:57.843

2

Is .Distinct() what you're looking for?

return database.Table<LG>.Where(x => x.id == WID).Distinct()

The following link contains useful material:

Example:

List<int> ages = new List<int> { 21, 46, 46, 55, 17, 21, 55, 55 };

IEnumerable<int> distinctAges = ages.Distinct();

Console.WriteLine("Distinct ages:");

foreach (int age in distinctAges)
{
  Console.WriteLine(age);
}

This code produces the following output:

Distinct ages:
21
46
55
17

edited Dec 08 '15 at 16:41

answered Dec 08 '15 at 15:44

Alex

37,502
51
204
332

1

you'll need to override the 'Equals' and the 'GetHashCode' methods – YuriG Dec 08 '15 at 15:53

score -1 · Answer 2 · answered Dec 08 '15 at 15:52

-1

in your LG object, you'll need to override the Equals and the GetHashCode methods.
Once you've done that, you can use the Distinct() function in LINQ

database.Table<LG>.Where(x => x.id == WID).Distinct()

answered Dec 08 '15 at 15:52

YuriG

368
3
14

Get all DISTINCT items in the List with LINQ

2 Answers2