public void MemoryCacheProviderGetOrCreateCacheTest() { MemoryCacheProvider target = MemoryCacheProvider.GetInstance(); IQueryable <Product> query = null; using (ProductContext context = new ProductContext()) { query = context.Products.OrderBy(one => one.ProductNumber).Where(one => one.IsActive); target.RemoveFromCache <Product>(query); var actual = target.GetOrCreateCache <Product>(query); Assert.AreEqual(2, actual.Count(), "Should have 2 rows"); SQLCommandHelper.ExecuteNonQuery("Update Products Set IsActive = 0"); actual = target.GetOrCreateCache <Product>(query); Assert.AreEqual(2, actual.Count(), "Should have 2 rows"); target.RemoveFromCache <Product>(query); actual = target.GetOrCreateCache <Product>(query); Assert.AreEqual(0, actual.Count(), "Should have 0 rows"); target.RemoveFromCache <Product>(query); } }
public void MemoryCacheProviderGetOrCreateCacheUsageTest() { EFCacheExtensions.SetCacheProvider(MemoryCacheProvider.GetInstance()); using (ProductContext context = new ProductContext()) { var query = context.Products .OrderBy(one => one.ProductNumber) .Where(one => one.IsActive).AsCacheable(); Assert.AreEqual(2, query.Count(), "Should have 2 rows"); SQLCommandHelper.ExecuteNonQuery("Update Products Set IsActive = 0"); query = context.Products .OrderBy(one => one.ProductNumber) .Where(one => one.IsActive).AsCacheable(); Assert.AreEqual(2, query.Count(), "Should have 2 rows"); IQueryable <Product> cleanupQuery = context.Products .OrderBy(one => one.ProductNumber) .Where(one => one.IsActive); EFCacheExtensions.RemoveFromCache <Product>(cleanupQuery); query = context.Products .OrderBy(one => one.ProductNumber) .Where(one => one.IsActive).AsCacheable(); Assert.AreEqual(0, query.Count(), "Should have 0 rows"); EFCacheExtensions.RemoveFromCache <Product>(cleanupQuery); } }
public void MemoryCacheProviderGetOrCreateCacheWithExpirationTest() { EFCacheExtensions.SetCacheProvider(MemoryCacheProvider.GetInstance()); MemoryCacheProvider target = MemoryCacheProvider.GetInstance(); IQueryable <Product> query = null; using (ProductContext context = new ProductContext()) { query = context.Products.OrderBy(one => one.ProductNumber).Where(one => one.IsActive); target.RemoveFromCache <Product>(query); TimeSpan cacheDuration = TimeSpan.FromSeconds(3); var actual = target.GetOrCreateCache <Product>(query, cacheDuration); Assert.AreEqual(2, actual.Count(), "Should have 2 rows"); SQLCommandHelper.ExecuteNonQuery("Update Products Set IsActive = 0"); actual = target.GetOrCreateCache <Product>(query, cacheDuration); Assert.AreEqual(2, actual.Count(), "Should have 2 rows"); Thread.Sleep(4000); actual = target.GetOrCreateCache <Product>(query, cacheDuration); Assert.AreEqual(0, actual.Count(), "Should have 0 rows"); target.RemoveFromCache <Product>(query); } }