Linq to SQL .Any() with multiple conditions?

Question

I'm trying to use .Any() in an if statement like so:

if(this.db.Users.Any(x => x.UserID == UserID)){
    // do stuff
}

Is there a way I can put multiple conditions inside of the .Any()? For example something like:

if(this.db.Users.Any(x => x.UserID == UserID AND x.UserName == UserName)){
    // do stuff
}

Or is there a better way to go about this?

Answer 1

Sure, use the && operator.

if(this.db.Users.Any(x => x.UserID == UserID && x.UserName == UserName)){
    // do stuff
}

If you can use it in an if statement, you can use it here. The lambda needs to evaluate to a bool.

Answer 2

if(this.db.Users.Any(x => x.UserID == UserID && x.UserName == UserName)){
    // do stuff
}