thilanka ishara

thilanka ishara

  • NA
  • 16
  • 11.1k

sql to LINQ

Aug 15 2014 4:51 AM
how can i convert bellow sql query to LINQ ?
 
SELECT dbo.AD_UserInReaders.ReaderID
FROM dbo.AD_UserInReaders
where sUserID=2 and ReaderID NOT IN
(SELECT dbo.TB_USER_DEVICE.nDeviceID FROM dbo.TB_USER_DEVICE WHERE (dbo.TB_USER_DEVICE.nUserIdn = 2))
 
 
Thank you 

Answers (8)