Entity Framework - Where is my Object Context?

entity-framework objectcontext
JoeMjr2 picture JoeMjr2 · Jan 9, 2013 · Viewed 28.9k times · Source

Ok, I'm obviously missing something very basic. I'm very new to Entity Framework.

I want to call stored procedures without importing them, so I was planning on using ExecuteStoreQuery(). According to the documentation, ExecuteStoreQuery is a method of ObjectContext. But, I have no idea where to get my ObjectContext.

I generated my entites using Database First. So far, I have been accessing my entities something like this:

var db = new MyEntities();

PRODUCT p = db.PRODUCTS.First(a => a.PRODUCTSKEY == thekey);

But I can't call db.ExecuteStoreQuery, becase db isn't an ObjectContext.

I've googled how to get ObjectContext from an entity. I find some answers, but they're all flagged with cautions, saying that it's a workaround, and only to use it if you have no other option. Ok, so what is the RIGHT way?

All examples that I've found for using ExecuteStoreQuery assume that you already have your ObjectContext. Not very helpful.

I found one website that stated that the ObjectContext is "automatically generated" by Entity Framework. If that's the case, then where is it?

I'm obviously missing something very simple here. This can't be that difficult.

Answer

Corey Adler picture Corey Adler · Jan 9, 2013

To get to the ObjectContext of your DbContext, all you'd need to do is the following:

var objectContext = ((IObjectContextAdapter)myDbContextObject).ObjectContext;

Related questions

c# working with Entity Framework in a multi threaded server

What is the best practice for working with entity framework in a multi threaded server? I'm using entity framework ObjectContext to manage all my database actions, now I know this context isn't thread safe, so for now when I need …

Read More
Entity Framework - refresh objects from database

I'm having trouble with refreshing objects in my database. I have an two PC's and two applications. On the first PC, there's an application which communicates with my database and adds some data to Measurements table. On my other PC, …

Read More
How to delete a list of object using ObjectContext?

Say you have code like this . using (CustomerContext db = new CustomerContext()) { var foundCustList=db.Customers.Where(c=>c.State=='-1').ToList();//Find all the customer which State is -1 foreach(var c in foundCustList) { db.DeleteObject(c); } db.…

Read More