Using Query Builder Methods against DbContext

Question

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?

score 3 · Accepted Answer · answered May 10 '13 at 01:02

3

Using this solved my problem:

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

answered May 10 '13 at 01:02

hattenn

4,371
9
41
80

1

It doesn't have to be that hard: `context.MyEntities.Where(x=>x.Id == 1);` – May 10 '13 at 03:27
1

I am aware of that of course, just trying to build dynamic queries. – hattenn May 10 '13 at 10:59

Using Query Builder Methods against DbContext

1 Answers1