How to return one variable from database?

Question

I am using this code:

var userRole = dbContext.Tables.FirstOrDefault(v => v.Name == userModel.descriptName);
if (userRole != null)
{
    userModel.User.Table = userRole;    
}

Now this code above works, but for userRole it returns both value from table (Id, Name). Now how to return only Id.

Answer 1

have you tried:

var userRole = dbContext.Tables.FirstOrDefault(v => v.Name == userModel.descriptName);
if (userRole != null)
{
    userModel.User.Table = userRole;
    var ID =  userModel.User.Table.Columns[1];  
}

Answer 2

var userRole = dbContext.Tables.FirstOrDefault(v => v.Name == userModel.descriptName
select v.Id);