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 ...

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

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.