RepoDb_Query_Cache_Filtered

RepoDb_Query_Cache_Filtered.cs

/* SqConnection */
var cache = CacheFactory.GetCache(); // new MemoryCache();
using (var connection = new SqlConnection(connectionString).EnsureOpen())
{
    var expirationInMinutes = 60 * 24; // 1 day
    var products = connection.Query<Product>(e => e.CustomerId == customerId,
        cacheKey: $"Customer-Product-{customerId}",
        cacheItemExpiration: expirationInMinutes,
        cache: cache);
}

/* Repository */
using (var repository = new DbRepository(connectionString))
{
    var expirationInMinutes = 60 * 24; // 1 day
    var products = repository.QueryAll<Product>(e => e.CustomerId == customerId,
        cacheKey: $"Customer-Product-{customerId}",
        cacheItemExpiration: expirationInMinutes);
}