mwhodges
asked on
sql to linq transformation
I need to change the following query to linq. Please help
SELECT Product_ProductServiceName , ProductClass
FROM Table1 AS a
WHERE (Letter = 'y') AND (Product_ProductServiceNam e NOT IN
(SELECT ProductServiceName
FROM Table2
WHERE (fk_Planid = '30')))
SELECT Product_ProductServiceName
FROM Table1 AS a
WHERE (Letter = 'y') AND (Product_ProductServiceNam
(SELECT ProductServiceName
FROM Table2
WHERE (fk_Planid = '30')))
ASKER
I'm using vb.net sorry. I tried to do the conversion but I have a question where did the o .customerid come from? Also when I get beyond the select new statment I get several other errors. Thank you so much for your help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much!! It worked perfectly
Open in new window