How to clear the entire second level cache in NHibernate

Question

I wish to clear the entire second level cache in NHibernate via code. Is there a way to do this which is independent of the cache provider being used? (we have customers using both memcache and syscache within the same application).

We wish to clear the entire cache because of changes external to the database may have occurred (and we have no guarantees re: which tables/entities were affected, so we have to assume the worst).

Answer 1

This should do:

sessionFactory.EvictQueries(); foreach (var collectionMetadata in sessionFactory.GetAllCollectionMetadata())          sessionFactory.EvictCollection(collectionMetadata.Key); foreach (var classMetadata in sessionFactory.GetAllClassMetadata())          sessionFactory.EvictEntity(classMetadata.Key);