MemoryCache

This class caches objects in memory, eliminating database round-trips for up to 180 minutes (configurable). It implements the ICache interface.

This is the default cache implementation used by the library.

Use-Cases

Use this class to cache objects fetched from the database in memory.

Usability

Pass an instance to the constructor of BaseRepository or DbRepository, or to fetch operations such as Query and QueryAll.

Customize

Define a custom interface that extends ICache.

public interface IJsonCache : ICache
{
    // More custom methods
}

Implement it in a cache class.

public class JsonCache : IJsonCache
{
    ...
}

public void ConfigureServices(IServiceCollection services)
{
    services.AddControllers();

    // Registration
    services.AddSingleton<IJsonCache, JsonCache>();
}

Inject it into the repository.

public class NorthwindRepository : DbRepository<SqlConnection>
{
    public NorthwindRepository(IOptions<AppSettings> settings,
        IJsonCache cache) // Injected
        : base(settings.Value.ConnectionString, cache)
    { }

    ...
}

Alternatively, use a factory class to provide a singleton ICache instance.

public static CacheFactory
{
    private static object _syncLock = new object();
    private static ICache _cache = null;
    
    public static ICache CreateCacher()
    {
        if (_cache == null)
        {
            lock (_syncLock)
            {
                if (_cache == null)
                {
                    _cache = new MemoryCache();
                }
            }
        }
        return _cache;
    }
}

Pass it to Query or QueryAll operations.

// Factory class as pointer to the cacher
var memoryCache = CacheFactory.CreateCacher();

// Pass it during the calls
using (var connection = new SqlConnection(connectionString))
{
    var products = connection.QueryAll<Product>(cacheKey: "CacheKey:Products", cache: memoryCache);
}

Or pass it to the BaseRepository or DbRepository constructor.

// Pass it on the constructor
public class NorthwithRepository : DbRepository<SqlConnection>
{
    public NorthwithRepository(IAppSettings settings)
        : base(settings.Value.ConnectionString, CacheFactory.CreateCacher())
    { }
}