how to write linq query of the below sql query

Question

SELECT [UserId] FROM [TU_LMS].[dbo].[MstUser] where RoleId in (3,5)

Naimish Makwana · Answer

You can use below: var userIds = dbContext.MstUser .Where(u => u.RoleId == 3 || u.RoleId == 5) .Select(u => u.UserId); Thanks

Tuhin Paul · Answer

SELECT [UserId] FROM [MstUser] WHERE [RoleId] IN (3, 5) LINQ code filters the MstUser table by checking if the RoleId column is contained in the roleIds list and then selects the UserId column. The equivalent SQL query uses the IN operator to filter the MstUser table by checking if the RoleId column is in the list of values (3, 5) and selects the UserId column.

Tuhin Paul · Answer

If you only need the UserId column, you can modify the Select() clause to only select that column. This can reduce the amount of data that needs to be retrieved from the database, which can improve performance. var roleIds = new List { 3, 5 }; var userIds = dbContext.MstUser.AsQueryable() .Where(u => roleIds.Contains(u.RoleId)) .Select(u => u.UserId);

Rajeesh Menoth · Answer

Hi, Try this: var userIds = from user in dbContext.MstUser where new int[] {3, 5 }.Contains(user.RoleId) select user.UserId;

Manikandan Murugesan · Answer

you can write the equivalent LINQ query for the above SQL query as follows: var result = from user in db.MstUser where user.RoleId == 3 || user.RoleId == 5 select user.UserId; Here, db is an instance of the DataContext class representing your database context. Alternatively, you can use the lambda syntax for the same query: var result = db.MstUser .Where(user => user.RoleId == 3 || user.RoleId == 5) .Select(user => user.UserId); This will give you a collection of UserId s that match the condition specified in the SQL query.

Raj Bhatt · Answer

from user in TU_LMS.dbo.MstUser where user.RoleId == 3 || user.RoleId == 5 select user.UserId

Uday Dodiya · Answer

Hi, you can write linq query as per below Option 1 var roles = new int[] { 3, 5 }; var result = dbContext.MstUser .Where(u => roles.Contains(u.RoleId)) .Select(u => u.UserId); Option 2 var result = dbContext.MstUser .Where(u => u.RoleId == 3 || u.RoleId == 5) .Select(u => u.UserId);

how to write linq query of the below sql query

Answers (7)