FirstOrDefault with Multiple Conditions

Question

In Link to Sql, this works fine:

User user = this.dataContext.Users.FirstOrDefault(p => p.User_ID == loginID); 

However, I would like to search using conditions like:

User user = this.dataContext.Users.FirstOrDefault(      p => p.User_ID == 250 && p => p.UserName == "Jack"); 

What's the correct way to do this?

Thanks.

Answer 1

var user = this.dataContext.Users.FirstOrDefault(      p => p.User_ID == 250 && p.UserName == "Jack"); 

The p => at the beginning counts for the whole expression. The syntax used here is a shorthand for

(p) =>       {          return p.User_ID == 250 && p.UserName == "Jack";       }