LINQ where Clause doubt

c# linq where clause
sss picture sss · Jan 2, 2009 · Viewed 9.5k times · Source

I have tried one where clause in Linq to get details about Users those who are Active and AllowLogin is also true.

So how can I compare the table values (both are boolean values) with true or false?

Answer

Jon Skeet picture Jon Skeet · Jan 2, 2009

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

Related questions

Group by in LINQ

Let's suppose if we have a class like: class Person { internal int PersonID; internal string car; } I have a list of this class: List<Person> persons; And this list can have multiple instances with same PersonIDs, for example: …

Read More
LINQ query on a DataTable

I'm trying to perform a LINQ query on a DataTable object and bizarrely I am finding that performing such queries on DataTables is not straightforward. For example: var results = from myRow in myDataTable where results.Field("RowNo") == 1 select results; This …

Read More
Join/Where with LINQ and Lambda

I'm having trouble with a query written in LINQ and Lambda. So far, I'm getting a lot of errors here's my code: int id = 1; var query = database.Posts.Join(database.Post_Metas, post => database.Posts.Where(x => x.…

Read More