SQLite Forum

EntityFramework database is locked
Login
Im' writing a ASP.NET WebForms app on .Net Framework 4.7.2
EntityFramework 6.4.4
System.Data.SQLite 1.0.113.1

When I try to execute a transaction, error below is raised.

            using (var context = new Entities())
            {
                using (var ts = context.Database.BeginTransaction())
                {
                 .....do something
                 context.SaveChanges();
                 ts.Commit();

                 }
            }



An error occurred while starting a transaction on the provider connection database is locked

This is my connection string.
<add name="DefaultConnection" connectionString="Data Source=|DataDirectory|Mydb.db;Version=3;Pooling=True;Max Pool Size=100;" providerName="System.Data.SQLite.EF6" />

I'll appreciate your help