Q:

Getting distinct rows in LINQ

I need to get the distinct row values from a table using LINQ. The query i used is
 var results = (from statename in dsobject.dbo_statetable select statename).Distinct();

It is giving all the rows of the table named "dbo_statetable" but i need only the distinct statename. What should be the query to achieve this?
Its sql equivalent is select distinct statename from dbo_statetable 

A:

You need to specify the property:
var results = (from x in dsobject.dbo_statetable select x.Statename).Distinct();
//                                                       ^^^^^^^^^^

The variable after from does not specify the column. It is like a table alias in SQL. Your LINQ statement is roughly equivalent to this SQL:
SELECT DISTINCT * FROM dbo_statetable AS statename

