Re: [sqlite] [SQLite3] [Mono] [Linux] "db is locked"

2018-06-25 Thread Phani Rahul Sivalenka
> SQLiteConnectionStringBuilder connBuilder = new > SQLiteConnectionStringBuilder(); We are setting these configs via the connection string in xml. This is same as the above. The following is the connection string that we are using: “data

[sqlite] [SQLite3] [Mono] [Linux] "db is locked"

2018-06-21 Thread Phani Rahul Sivalenka
Hello, We have an ASP.NET Web application running with Mono on Linux. Uses System.Data.SQLite library with an interop generated with a specific set configuration to interact with the SQLite file. When we do a read operation and write/update operation on the SQLite DB, the write operation gets

[sqlite] Best approach for applying DB migrations to an existing SQLite DB

2018-08-02 Thread Phani Rahul Sivalenka
Our application is an ASP.NET MVC application with an N-Tier architecture running on Mono in Linux. Interaction with SQLite DB is done through ADO.Net using System.Data.SQLite provider. Can you suggest best approach for implementing and applying migrations to the DB?

[sqlite] [System.Data.SQLite] BusyTimeout and DefaultTimeout are not picked up from the connection string

2018-08-22 Thread Phani Rahul Sivalenka
Hello, The question is related to the System.Data.SQLite library's connection string parsing. We have defined the connection string as follows: data source=;DateTimeKind=Utc;Version=3;Pooling=True;Synchronous=Off;journal mode=Memory;busytimeout=30001;default timeout=31 When a new

Re: [sqlite] [SQLite3] [Mono] [Linux] "db is locked"

2018-07-03 Thread Phani Rahul Sivalenka
As per our observation, the initial write operations on the sqlite db file throw "db is locked" error. After a certain time (around an hour) write operations start working and we are able to do all the operations as required. On Mon, Jun 25, 2018 at 7:37 PM Phani Rahul Sivale