C# - How can I do a simple query in Entity Framework using lambda?

Question

I have an Entity Framework model semi-working right now, but I'm having trouble performing a query to return database records with a Where() clause.

I am trying to line:

db.BlackstoneUsers.Where(u => u.Email == User.Email); 

but I get the exception:

Expression cannot contain lambda expressions

I think this should be simple, but I'm just learning Entity and LINQ/Lambda.

Does anyone have any pointers?

Answer 1

try setting the email outside the call

var email = User.Email
db.BlackstoneUsers.Where(u => u.Email == email);