ansaurus

Question

Answer 1

+8 A:

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

Jon Skeet 2009-01-02 08:03:30

If all you want is the details (instead of the whole User), you can do a "select user.Detail"

Bramha Ghosh 2009-01-02 08:08:37

Yes - but I assumed that when the OP said "details" he meant "all fields of the table" rather than a specific field called "details".

Jon Skeet 2009-01-02 08:19:28

I took the freedom to format the question to match Jon's answer.

David Schmitt 2009-01-02 09:38:56

Answer 2

A:

thank you jon Skeet

2009-01-02 08:09:47

Please use Add Comment to respond to a specific answer, SO is not a Forum or a newsgroup

AnthonyWJones 2009-01-02 08:26:06

@AnthonyWJones - not enough rep to add comments; you need 50

Marc Gravell 2009-01-02 09:45:11

LINQ where Clause doubt