How we write LINQ Query

Question

How to write this query in LINQ select DISTINCT(Level2) from Level Pass Only Column name and return in distinct value of Column

Amit Gupta · Answer

Check out the below link http://stackoverflow.com/questions/12580360/select-distinct-values-from-a-list-using-linq-in-c-sharp

Manas Mohapatra · Answer

Try like below: var result = (from rec in Level select rec.Level2).Distinct(); foreach (var p in result) { Console.WriteLine(p); }

Bikesh Srivastava · Answer

see this query....... var result = (from r in Level select r.Level2).Distinct();

Manas Mohapatra · Answer

In your code you are fetching all records then FirstorDefault. It will return only one records. So when you are thinking to return distinct values. Please provide the requirement..

krishna kanhaiya · Answer