How can we maintain concurrency in Sqlite database?

Hi Sumit,

modify your code like this:
--------------------------------------------------
public bool ExecuteANonQuery(string sql, int i = 0)
{
try
{
Open();//for connection open
using (IDbCommand command = _dbCon.CreateCommand())
{
command.CommandText="PRAGMA locking_mode = EXCLUSIVE; BEGIN EXCLUSIVE;"+sql+" COMMIT;";
int ww = command.ExecuteNonQuery();

}
return true;
}
catch (SQLiteException ex)
{
if (ex.Message.Contains("readonly database"))
{
i++;
if (i < 50)
{
Thread.Sleep(100);
return ExecuteANonQuery(sql, i);
}
}
throw;
}
catch { throw; }
finally { Close(); }
---------------------------------------------------

I'm glad I could help.