How do I convert following query into Linq query--
SELECT ID FROM Table1
INNER JOIN Table2
ON Table1.ID IN (SELECT ID FROM @Temp)
Asked
Active
Viewed 248 times
0
Jakob Bowyer
- 33,878
- 8
- 76
- 91
Faiyaz
- 135
- 1
- 2
- 14
-
how about spelling from correctly? – Mitch Wheat Apr 15 '13 at 11:36
-
are you doing this with dynamic SQL ? what is @Temp? I don't get what kind of join you are trying to do in there. I suggest you have a look here: http://stackoverflow.com/questions/373541/how-to-do-joins-in-linq-on-multiple-fields-in-single-join – Davide Piras Apr 16 '13 at 08:26