LINQ

LINQ to SQL and the IN Clause

Dec 22, 2011 No Comments by

As I am continuing to convert queries from T-SQL to LINQ (to SQL), I came across a scenario where I am using an IN query to pull back a result set where a criteria is within a given range of values.  Here is the original SQL:   SELECT DISTINCT File_Format.File_Format_Key, File_Format_Name, Exit_Call_Routine.Exit_Call_Routine_Key, Exit_Call_Routine.Exit_Call_Routine_Text FROM File_Format [...]

C#, LINQ, SQL Read more