How to fix SQLITE_LOCKED_SHAREDCACHE: Conflict within shared cache in SQLite

// In-memory database with shared cache
DataSource=file::memory:?cache=shared

// Or using URI format
DataSource=:memory:?cache=shared

// Or the SQLITE_OPEN_SHAREDCACHE flag in your sqlite3_open_v2() call

// Before (with shared cache - causes SQLITE_LOCKED_SHAREDCACHE)
var connectionString = "DataSource=file::memory:?cache=shared";

// After (private cache - default)
var connectionString = "DataSource=:memory:?cache=private";
// Or simply
var connectionString = "DataSource=:memory:";

// Or remove cache parameter entirely
var connectionString = "Data Source=mydata.db";

// When creating your connection
var connectionString = "Data Source=mydata.db";
using (var connection = new SqliteConnection(connectionString))
{
    connection.Open();
    
    // Enable WAL mode
    using (var command = connection.CreateCommand())
    {
        command.CommandText = "PRAGMA journal_mode = WAL";
        command.ExecuteNonQuery();
    }
}

const int maxRetries = 5;
int retryCount = 0;

while (retryCount < maxRetries)
{
    try
    {
        // Execute your database operation
        connection.Execute(sql);
        break; // Success
    }
    catch (SqliteException ex) when (ex.SqliteErrorCode == 6) // SQLITE_LOCKED
    {
        retryCount++;
        if (retryCount >= maxRetries) throw;
        
        // Exponential backoff
        int delayMs = (int)Math.Pow(2, retryCount) * 10;
        await Task.Delay(delayMs);
    }
}

// Test concurrent access
var tasks = Enumerable.Range(0, 10)
    .Select(i => Task.Run(() => ExecuteDatabaseOperation(i)))
    .ToArray();

await Task.WhenAll(tasks);
// Should complete without SQLITE_LOCKED_SHAREDCACHE errors