Entity Framework – async select with where condition

You can do it like this.

If you need to retrieve one object then :

var d = await db.Employee.FirstOrDefaultAsync(x => x.FirstName == "Jack");

If you need to retrieve list then :

 var d = await db.Employee.Where(x => x.FirstName == "Jack").ToListAsync();