What is the exact LINQ Query for this SQL Query?

Question

i am very new in LINQ so,I can't understand what the exact Linq query is of this SQLquery.

Please give exact Linq Query similar to this SQL query.

Select  * From tblProduct 
Where ProductId In 
      (Select  ProductId  from  tblViewer Where ViewerId = 123)

help me i cant understand how to use **linqpad** as sql-to-linq converter — Sk Asraf, Jun 23 '16 at 17:17

score 4 · Accepted Answer · answered Jun 23 '16 at 17:10

4

Contains is the most straightforwrad way to implement an IN statement, so it would be something like:

tblProduct.Where(p => tblViewer.Where(v => v.ViewerId == 123)
                               .Select(v => v.ProductId)
                               .Contains(p.ProductId)
                );

answered Jun 23 '16 at 17:10

D Stanley

149,601
11
178
240

@D Stanley ..can u say how to use **linqpad** as **sql** to **linq** converter – Sk Asraf Jun 23 '16 at 17:13
I don't think you can - you can see the SQL generated from a Linq statement but not the other way around. – D Stanley Jun 23 '16 at 17:31
yes, i can convert **linq to sql** but opposite can't using **Linqpad** – Sk Asraf Jun 23 '16 at 18:18

What is the exact LINQ Query for this SQL Query?

1 Answers1