How can I return all the columns of a table using multiple distinct columns in Linq?

You want to use GroupBy: var distinctModelYears = cars. GroupBy(c => new { c. Year, c.

Model }) . Select(g => g.First()) //Take one from each group That will find all "distinct" years and models so there will only be one 2008 Accord, one 2009 Accord, etc.

You want to use GroupBy: var distinctModelYears = cars. GroupBy(c => new { c. Year, c.

Model }) . Select(g => g.First()) //Take one from each group ; That will find all "distinct" years and models so there will only be one 2008 Accord, one 2009 Accord, etc.

Taking the above example, say I have columns like Year, Model and Make. I need to return all the columns (Year, Model and Make) Group by Year and Model. So, combination of Year and Model will be unique.

– Mohit Dec 11 '09 at 21:18.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.