LiteX.Cache.SQLite 8.1.0

SQLite caching based on SQLite database.
     Small library for manage cache with SQLite. A quick setup for SQLite Caching.
     Wrapper library is just written for the purpose to bring a new level of ease to the developers who deal with SQLite Cache integration with your system.
    
     LiteXCache is simple yet powerful and very high-performance cache mechanism and incorporating both synchronous and asynchronous usage with some advanced usages of caching which can help us to handle caching more easier!
     Provide Cache service for any type of application (.NET Core, .NET Standard).
     Very simple yet advanced configuration. Minimal (one line) code configuration is required.

Install-Package LiteX.Cache.SQLite -Version 8.1.0

dotnet add package LiteX.Cache.SQLite --version 8.1.0

<PackageReference Include="LiteX.Cache.SQLite" Version="8.1.0" />

paket add LiteX.Cache.SQLite --version 8.1.0

PM> Install-Package LiteX.Cache.SQLite

{  
  //LiteX SQLite Config settings (Optional)
  "SQLiteConfig": {
    "FilePath": "",
    "FileName": "",
    "EnableLogging": true
  }
}

public class Startup
{
    public void ConfigureServices(IServiceCollection services)
    {
        // 1. Use default configuration from appsettings.json's 'SQLiteConfig'
        services.AddLiteXSQLiteCache();

        //OR
        // 2. Load configuration settings using options.
        services.AddLiteXSQLiteCache(option =>
        {
            option.FileName = "";
            option.FilePath = "";
            option.OpenMode = Microsoft.Data.Sqlite.SqliteOpenMode.ReadWriteCreate;
            option.CacheMode = Microsoft.Data.Sqlite.SqliteCacheMode.Default;
            option.EnableLogging = false;
        });

        //OR
        // 3. Load configuration settings on your own.
        // (e.g. appsettings, database, hardcoded)
        var sqLiteConfig = new SQLiteConfig()
        {
            FileName = "",
            FilePath = "",
            OpenMode = Microsoft.Data.Sqlite.SqliteOpenMode.ReadWriteCreate,
            CacheMode = Microsoft.Data.Sqlite.SqliteCacheMode.Default,
            EnableLogging = false,
        };
        services.AddLiteXSQLiteCache(sqLiteConfig);
    }    
    public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory)
    {
        //SQLite
        app.UseLiteXSQLiteCache();
    }
}

PM> Install-Package LiteX.Cache.SQLite

{  
  //LiteX SQLite Config settings (Optional)
  "SQLiteConfig": {
    "FilePath": "",
    "FileName": "",
    "EnableLogging": true
  }
}

public class Startup
{
    public void ConfigureServices(IServiceCollection services)
    {
        // 1. Use default configuration from appsettings.json's 'SQLiteConfig'
        services.AddLiteXSQLiteCache();

        //OR
        // 2. Load configuration settings using options.
        services.AddLiteXSQLiteCache(option =>
        {
            option.FileName = "";
            option.FilePath = "";
            option.OpenMode = Microsoft.Data.Sqlite.SqliteOpenMode.ReadWriteCreate;
            option.CacheMode = Microsoft.Data.Sqlite.SqliteCacheMode.Default;
            option.EnableLogging = false;
        });

        //OR
        // 3. Load configuration settings on your own.
        // (e.g. appsettings, database, hardcoded)
        var sqLiteConfig = new SQLiteConfig()
        {
            FileName = "",
            FilePath = "",
            OpenMode = Microsoft.Data.Sqlite.SqliteOpenMode.ReadWriteCreate,
            CacheMode = Microsoft.Data.Sqlite.SqliteCacheMode.Default,
            EnableLogging = false,
        };
        services.AddLiteXSQLiteCache(sqLiteConfig);
    }    
    public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory)
    {
        //SQLite
        app.UseLiteXSQLiteCache();
    }
}

Release Notes

Upgrade to .NET Core 3.x.
     Update libraries and SDKs to latest version.

     Last release notes,
     Multiple provider support (using provider factory) - AddLiteXSQLiteCacheFactory
     Code re-factoring and optimization changes

Dependencies

• .NETStandard 2.0

  • Dapper (>= 2.0.30)
  • LiteX.Cache.Core (>= 8.1.0)
  • LiteX.Log (>= 2.0.0)
  • Microsoft.Data.SQLite (>= 3.1.3)
  • Microsoft.Extensions.Configuration (>= 3.1.3)
  • Microsoft.Extensions.Configuration.Binder (>= 3.1.3)
  • Microsoft.Extensions.DependencyInjection (>= 3.1.3)
  • Newtonsoft.Json (>= 12.0.3)

Used By

Version History