SQL to LINQ Query.

11y ago

I have done it with below query :-

var query = (from ud in db.Users_Device where
(from mc in db.Master_Contact where (mc.AddedUserId == 305)) select mc.UserId).Contains(ud.UserId)
select ud.DeviceId).ToList();

Thanks for Reply

0

Vulpes11y ago

Try this:

var query = from ud in Users_Device where

(from mc in Master_Contact where mc.AddedUserId == 305).Contains(ud.userid)

select new{ud.userid, ud.deviceid};

0

Manish Kumar Choudhary11y ago

Go through following link it will help you

https://msdn.microsoft.com/en-us/library/bb397678.aspx

http://stackoverflow.com/questions/2055254/how-to-write-a-linq-to-entities-query-with-list-in-a-where-condition

0

Vikram Agrawal11y ago

Hi Dipesh,

you can try this

var innerQuery = from mc in Master_contact where mc.AddedUserId = 305 select mc.userid ;

var result = from ud in Users_Device where innerQuery.Contains(ud.Userid ) select ud.userid,ud.deviceid ;

thanks

0