LINQ to DataSet, distinct by multiple columns

linq distinct linq-to-dataset
Ganesha picture Ganesha · Apr 1, 2009 · Viewed 34.3k times · Source

Just wanted to check if there is way to do distinct by multiple columns. Thanks in advance!!!

BTW, I found a great LINQ extension here but need some guidance to use it for multiple columns

Answer

Marc Gravell picture Marc Gravell · Apr 1, 2009

Well, you can do the projection first:

var qry = db.Customers.Select(cust => new {cust.ID, cust.Name, cust.Region})
                    .Distinct();

Or in query syntax:

var qry = (from cust in db.Customers
          select new {cust.ID, cust.Name, cust.Region}).Distinct();

That do?

Related questions

LINQ's Distinct() on a particular property

I am playing with LINQ to learn about it, but I can't figure out how to use Distinct when I do not have a simple list (a simple list of integers is pretty easy to do, this is not the …

Read More
Get a list of distinct values in List

In C#, say I have a class called Note with three String member variables. public class Note { public string Title; public string Author; public string Text; } And I have a list of type Note: List<Note> Notes = new …

Read More
Using .Select and .Where in a single LINQ statement

I need to gather Distinct Id's from a particular table using LINQ. The catch is I also need a WHERE statement that should filter the results based only from the requirements I've set. Relatively new to having to use LINQ …

Read More