How to use SQL Cache Dependency Wtih EF DbContext?

Question

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 user. But I feel like utilizing this technology would be the best way to invalidate the cache.

any help is appreciated.

Chase

Out of curiosity why do you want to refresh context if data change? Do you understand consequences? — Ladislav Mrnka
– Ladislav Mrnka, Commented Mar 21, 2011 at 19:08

Kris Ivanov · Accepted Answer · 2011-03-19 21:01:51Z

1

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.

answered Mar 19, 2011 at 21:01

Kris Ivanov

10.6k2 gold badges26 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ladislav Mrnka · Accepted Answer · 2011-03-19 21:25:07Z

1

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.

answered Mar 19, 2011 at 21:25

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

Collectives™ on Stack Overflow

How to use SQL Cache Dependency Wtih EF DbContext?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related