Now, this will still not be particularly quick if you don't have any decent indexes. Have SQL Management Studio generate the execution plan for this query and see what's taking the most time.

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

Do you want to find out how to avoid duplicates in the results of a SQL SELECT query? This article will show you how. To avoid duplicate results: Simply use the DISTINCT clause and between the SELECT ...

JSON and Entity Framework As a general remark, the JSON support in SQL Server 2016 is primarily exposed through the T-SQL syntax, as tooling is quite limited now. In particular, EF doesn't currently ...