Using SqlDependency with Entity Framework 4.1 and MemoryCache

See more:

C#

SQL

ADO.NET

C#4.0

cache

I’m using Entity Framework 4.1 (Code-First) and SQL2008, and I have one question: Is it possible to include SqlDependency (Sytem.Runtime.Caching) to invalidate the cache when one or more tables are changing with EF 4.1??

I’m trying to find any documentation about this, but I just found some articles that is not work properly.
I configured the SQL Server to enable Service Broker and I tried to use SqlCommand to subscription the Query Notification Service. The code runs OK, but when the data chances the cache isn’t destroyed.

Does anyone had to implement of this functionality using Entity Framework 4.1?

Thanks in advanced,
Alessandro Brito.