How to use SQL Cache Dependency Wtih EF DbContext?

I found this article on using Sql Cache Dependency with Linq2SQL. http://www.dotnetcurry.com/ShowArticle.aspx?ID=263

is it possible to do this same thing in Entity Framework with DbContext?

I have a multi-database app so each DbContext Instance Connection is different depending on the 开发者_C百科user. But I feel like utilizing this technology would be the best way to invalidate the cache.

any help is appreciated.

Chase

---

Take a look at this, will give you a starting point: http://blogs.msdn.com/b/jkowalski/archive/2009/06/11/tracing-and-caching-in-entity-framework-available-on-msdn-code-gallery.aspx, I tried it and it works fine but I have chosen to use a more custom and light weight approach.

Basically I retrieve the TraceString which is nothing but the raw SQL from my IQueriable<T> and create a standard SqlCacheDependency cache entry.

---

Your DbContext should live only for single unit of work. In your case for single request processing so there is no reason to involve any database dependency in EF.