LINQ where clause is doubt

Question

I tried one where clause in Linq to get information about User , which are also Active and AllowLogin .

So, how can I compare table values ​​(both are logical values) with true or false?

Answer 1

Just use something like:

 var query = from user in context.Users where user.Active && user.AllowLogin select user; 

Alternatively, you can write the same query without a query expression:

 var query = context.Users.Where(user => user.Active && user.AllowLogin); 

Answer 2

 var qry = (from en in Contaxt.tblStatDefinitions where en.Name == "Sunandan" select en.id).Single();