Setting Sqlite ThreadingMode when using sqlite-net + async

Question

I'm trying to set Sqlite ThreadMode to Serialized in my Xamarin.iOS project. Using classic Sqlite, one finds this method on the connection class:

SqliteConnection.SetConfig(SQLiteConfig.Serialized);

However I'm using sqlite-net (+async) and can't find a way to set this configuration property.

Any suggestions?

Mark Gibaud · Accepted Answer · 2015-01-16 14:24:10Z

5

Ok, I had to update SQLite-Net (and SQLite-Net-PCL etc) to 2.5.

Then this option can be accessed through the platform specific implementation:

public Repository(IPlatform platform)
    {
        _platform = platform;
        _platform.SqlitePlatform.SQLiteApi.Config(ConfigOption.Serialized);

        _db = new SQLiteAsyncConnection(() =>
            new SQLite.Net.SQLiteConnectionWithLock(
            _platform.SqlitePlatform,
            new SQLite.Net.SQLiteConnectionString(_platform.DatabasePath, true)));
    }

answered Jan 16, 2015 at 14:24

Mark Gibaud

2,06123 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

JKennedy Over a year ago

Does this constructor still exist? I can't find it in the github repository linked and neither can I find it in my code. What namespaces do I need? What is the IPlatform interface?

fire in the hole Over a year ago

there is no such constructor

Mark Gibaud Over a year ago

github.com/oysteinkrog/SQLite.Net-PCL/blob/master/src/…

Collectives™ on Stack Overflow

Setting Sqlite ThreadingMode when using sqlite-net + async

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related