public void MyTestInitialize()
{
using (ProductContext context = new ProductContext())
{
context.Products.ToList().ForEach(one => context.Products.Remove(one));
context.SaveChanges();
Product p = new Product()
{
IsActive = true,
ProductName = "Plates",
ProductNumber = "001"
};
context.Products.Add(p);
p = new Product()
{
IsActive = true,
ProductName = "Cups",
ProductNumber = "002"
};
context.Products.Add(p);
p = new Product()
{
IsActive = false,
ProductName = "Napkins",
ProductNumber = "003"
};
context.Products.Add(p);
context.SaveChanges();
}
}
public void MyTestCleanup()
{
using (ProductContext context = new ProductContext())
{
context.Products.ToList().ForEach(one => context.Products.Remove(one));
context.SaveChanges();
}
}
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 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 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);
}
}
