public SQLiteCachingTest()
{
IServiceCollection services = new ServiceCollection();
services.AddSQLiteCache(options =>
{
options.FileName = "";
options.FilePath = "";
options.CacheMode = Microsoft.Data.Sqlite.SqliteCacheMode.Default;
options.OpenMode = Microsoft.Data.Sqlite.SqliteOpenMode.Memory;
});
IServiceProvider serviceProvider = services.BuildServiceProvider();
_dbProvider = serviceProvider.GetService <ISQLiteDatabaseProvider>();
var conn = _dbProvider.GetConnection();
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
conn.Execute(ConstSQL.CREATESQL);
_provider = new DefaultSQLiteCachingProvider(_dbProvider, new OptionsWrapper <SQLiteOptions>(new SQLiteOptions()));
_defaultTs = TimeSpan.FromSeconds(30);
}
public SQLiteCachingTest()
{
IServiceCollection services = new ServiceCollection();
services.AddEasyCaching(x =>
x.UseSQLite(options =>
{
options.DBConfig = new SQLiteDBOptions
{
FileName = "s1.db",
CacheMode = Microsoft.Data.Sqlite.SqliteCacheMode.Default,
OpenMode = Microsoft.Data.Sqlite.SqliteOpenMode.Memory,
};
})
);
IServiceProvider serviceProvider = services.BuildServiceProvider();
var _dbProviders = serviceProvider.GetServices <ISQLiteDatabaseProvider>();
_dbProvider = _dbProviders.FirstOrDefault();
var conn = _dbProvider.GetConnection();
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
conn.Execute(ConstSQL.CREATESQL);
_provider = new DefaultSQLiteCachingProvider(EasyCachingConstValue.DefaultSQLiteName, _dbProviders,
new SQLiteOptions());
_defaultTs = TimeSpan.FromSeconds(30);
}
