how to write linq query of the below sql query

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.

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

Hi,

Try this:

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

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 UserIds that match the condition specified in the SQL query.

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

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

You can use below:

var userIds = dbContext.MstUser
                .Where(u => u.RoleId == 3 || u.RoleId == 5)
                .Select(u => u.UserId);

Thanks