In a talkback comment to my review, "CSharper" pointed me at one solution to finding the LINQ equivalent of a SQL "SELECT DISTINCT" query: tack on a LINQ .Distinct () method call to the query ...

SELECT DISTINCT company, last_name, first_name FROM Sales; You can still use DISTINCT when narrowing and sorting your results, as with any SELECT statement.

Sql query help, selecting newest distinct record Hoostine May 12, 2008 Jump to latest Follow Reply ...