ExecuteStoreQuery with Dbcontext

c# linq entity-framework objectcontext dbcontext
Chuck Norris picture Chuck Norris · Dec 28, 2011 · Viewed 18.2k times · Source

I want to use ExecuteStoreQuery function of Entity Framework and I was wondered that my context variable didn't have ExecuteStoreQuery method.

So, I discovered that it's a method of ObjectContext class, but I've already used DbContext for my application. I simply had tried to change DbContext with ObjectContext, but it brought some errors(for example, in ObjectContext isn't OnModelCreating method).

How can I use ExecuteStoreQuery with DbContext and if I can't, is any alternatives of ExecuteStoreQuery in DbContext?

Answer

Wouter de Kort picture Wouter de Kort · Dec 28, 2011

A DbContext is simply a wrapper around the ObjectContext.

You can still access the original ObjectContext by using IObjectContextAdapter

(dbContext as IObjectContextAdapter).ObjectContext;

Related questions

Entity Framework. Delete all rows in table

How I can quickly remove all rows in table using Entity Framework? I am currently using: var rows = from o in dataDb.Table select o; foreach (var row in rows) { dataDb.Table.Remove(row); } dataDb.SaveChanges(); However, it takes a …

Read More
Linq Syntax - Selecting multiple columns

This is my Linq Syntax which I am using to my entity model IQueryable<string> objEmployee = null; objEmployee = from res in _db.EMPLOYEEs where (res.EMAIL == givenInfo || res.USER_NAME == givenInfo) select res.EMAIL; How can I select …

Read More
Entity Framework select distinct name

How can I do this SQL query with Entity Framework? SELECT DISTINCT NAME FROM TestAddresses

Read More