BeginTransaction can only be called when the connection is open error in SqLite provider

[springjazzy]

I keep getting BeginTransaction can only be called when the connection is open error while using SqLite provider,

How does it supposed to work? What am I doing wrong?

EasyCaching/src/EasyCaching.SQLite/Configurations/SQLiteDatabaseProvider.cs

Line 55 in 159a930

var threadId = Thread.CurrentThread.ManagedThreadId;

Here we create "connection pool" per ManagedThreadId. All connection by default are closed.

Here is the only place I found where connection is explicitly opened:

EasyCaching/src/EasyCaching.SQLite/DefaultSQLiteCachingProvider.cs

Line 93 in 159a930

conn.Open();

In, asp.net core environment I frequently encounter thread switching which cause SQLiteDatabaseProvider not to use opened connection but to create new connection (closed). Later when BeginTransaction is called

EasyCaching/src/EasyCaching.SQLite/DefaultSQLiteCachingProvider.cs

Line 251 in 159a930

var tran = _cache.BeginTransaction();

I get BeginTransaction can only be called when the connection is open exception.

[catcherwong]

@springjazzy Thanks for your interest in this project.

We will take a look ASAP.

This SQLite issue is related with #260 .

BTW, which version are you using?

[springjazzy]

Thanks for reply.
I'm using 1.3.0 version.