Gree.Microsoft.Extensions.Caching.SQLite 2.1.2

Distributed cache implementation of Microsoft.Extensions.Caching.Distributed.IDistributedCache using SQLite.

Install-Package Gree.Microsoft.Extensions.Caching.SQLite -Version 2.1.2
dotnet add package Gree.Microsoft.Extensions.Caching.SQLite --version 2.1.2
<PackageReference Include="Gree.Microsoft.Extensions.Caching.SQLite" Version="2.1.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Gree.Microsoft.Extensions.Caching.SQLite --version 2.1.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

source code :
https://github.com/zhuang1125/Microsoft.Extensions.Caching.SQLite.git

use this like Microsoft.Extensions.Caching.SqlServer
but no SchemaName info.
you must create table before use this pkg.

below is net core config:
{
//"SqlConnectionString": "Server=localhost;Database=CacheSampleDb;Trusted_Connection=True;",
"SQLiteConnectionString": "Filename=sqliteSamplecache.db",
"TableName": "TestCache"
}

below is SQLite Table DDL

String tableCommand = "CREATE TABLE IF NOT " +
"EXISTS "+ cacheOptions.TableName + " (" +
"Id TEXT PRIMARY KEY, " +
"Value BLOB NOT NULL," +
"ExpiresAtTime INTEGER NOT NULL," +
"SlidingExpirationInSeconds INTEGER NULL," +
"AbsoluteExpiration INTEGER NULL )";

source code :
https://github.com/zhuang1125/Microsoft.Extensions.Caching.SQLite.git

use this like Microsoft.Extensions.Caching.SqlServer
but no SchemaName info.
you must create table before use this pkg.

below is net core config:
{
//"SqlConnectionString": "Server=localhost;Database=CacheSampleDb;Trusted_Connection=True;",
"SQLiteConnectionString": "Filename=sqliteSamplecache.db",
"TableName": "TestCache"
}

below is SQLite Table DDL

String tableCommand = "CREATE TABLE IF NOT " +
"EXISTS "+ cacheOptions.TableName + " (" +
"Id TEXT PRIMARY KEY, " +
"Value BLOB NOT NULL," +
"ExpiresAtTime INTEGER NOT NULL," +
"SlidingExpirationInSeconds INTEGER NULL," +
"AbsoluteExpiration INTEGER NULL )";

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
2.1.2 163 10/20/2018