SQL to LINQ Query.

Question

Hello All Want to change below sql query to Linq query : select useriddeviceid from Users_Device where UserId in(select userid from Master_Contact where AddedUserId = 305) pl help me. Thanks.

Dipesh Tare · Answer

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

Vulpes · Answer

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};

Manish Kumar Choudhary · Answer

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

Vikram Agrawal · Answer

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.useridud.deviceid ; thanks