Using Query Builder Methods against DbContext

1.3k Views Asked by At

I would like to use the "Query Builder Methods" on my DbContext like following:

using (var context = new MyDbContext())
{
    var query = context.MyEntities.Where("Id = @id", new ObjectParameter("id", 1));
}

But it cannot resolve this specific overload of Where. What am I missing here?

1

There are 1 best solutions below

2
hattenn On BEST ANSWER

Using this solved my problem:

var objectContext = ((IObjectContextAdapter) context).ObjectContext;
var query = objectContext.CreateObjectSet<MyEntities>().Where("it.Id = @id", new ObjectParameter("id", 1));