SQLite Database Locked exception

by

Somewhere along the way a connection is getting left open. Get rid of OpenConnection and CloseConnection and change ExecuteNonQuery to this:

using (SQLiteConnection c = new SQLiteConnection(ConnectionString))
{
    c.Open();
    using (SQLiteCommand cmd = new SQLiteCommand(sql, c))
    {
        cmd.ExecuteNonQuery();
    }
}

Further, change the way you read data to this:

using (SQLiteConnection c = new SQLiteConnection(ConnectionString))
{
    c.Open();
    using (SQLiteCommand cmd = new SQLiteCommand(sql, c))
    {
        using (SQLiteDataReader rdr = cmd.ExecuteReader())
        {
            ...
        }
    }
}

Do not attempt, to manage connection pooling on your own like you are here. First, it’s much more complex than what you have coded, but second, it’s handled already inside the SQLiteConnection object. Finally, if you’re not leveraging using, you’re not disposing these objects properly and you end up with issues like what you’re seeing now.

More Related Contents:

  1. What ‘additional configuration’ is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project?
  2. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  3. MetadataException: Unable to load the specified metadata resource
  4. Get output parameter value in ADO.NET
  5. Is there a .NET/C# wrapper for SQLite? [closed]
  6. When should “SqlDbType” and “size” be used when adding SqlCommand Parameters?
  7. SQLite Insert very slow?
  8. Is it necessary to manually close and dispose of SqlDataReader?
  9. Populate data table from data reader
  10. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  11. Difference with Parameters.Add and Parameters.AddWithValue
  12. SqlConnection SqlCommand SqlDataReader IDisposable
  13. Create SQLite Database and table
  14. Calling Oracle stored procedure from C#?
  15. Insert into C# with SQLCommand
  16. MultipleActiveResultSets=True or multiple connections?
  17. How to pass a table-value parameter
  18. SQLite .NET performance, how to speed up things?
  19. How DataReader works?
  20. How to keep single SQL Server connection instance open for multiple request in C#?
  21. Create/Use User-defined functions in System.Data.SQLite?
  22. SQLite keeps the database locked even after the connection is closed
  23. Enabling Foreign key constraints in SQLite
  24. Options for using System.Data.SQLite in a 32bit and 64bit C# world
  25. What is the difference between dataview and datatable?
  26. Reading a date using DataReader
  27. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  28. How do I connect to a SQL database from C#?
  29. .net connection pooling
  30. How does the SQLite Entity Framework 6 provider handle Guids?

Leave a Comment