Xamarin.Forms using SQLite.Net.Async

Question

I have followed the instructions here http://developer.xamarin.com/guides/cross-platform/xamarin-forms/working-with/databases/ - to connect to the SQLite database synchronously.

public SQLiteConnection GetConnection()
{
    var dbFilname = "localDB.db3";
    string docsPath = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal);
    var path = Path.Combine(docsPath, dbFilname);

    var plat = new SQLitePlatformAndroid();
    var conn = new SQLiteConnection(plat, path);
    return conn;
}

I want to change it to an asynchronous connection (SQLiteAsyncConnection) but can't get it to work.

According to the instructions here - https://components.xamarin.com/gettingstarted/sqlite-net -it just needs the path as a parameter

var conn = new SQLiteAsyncConnection(path);

that doesn't work, the error says that the parameters expected are:

a connection function, a TaskScheduler and TaskCreationOptions

I have no idea what to do and have not been able to find any examples that work.

Thanks in advance

SKall · Accepted Answer · 2014-09-20 16:43:14Z

3

You could simply reuse the GetConnection method you already have and create async connection like this:

var asyncDb = new SQLiteAsyncConnection(() => GetConnection());

answered Sep 20, 2014 at 16:43

SKall

5,2341 gold badge18 silver badges25 bronze badges

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

2 Comments

user1667474 Over a year ago

Thankyou - and for anyone else with the same problem, there is a solution here (captechconsulting.com/blog/nicholas-cipollina/…) that also works

27k1 Over a year ago

Dead link please delete or change,

rubStackOverflow · Accepted Answer · 2015-05-11 01:52:39Z

0

Xamarin Platforms Android Config, iOS and WP basicaly equal

public SQLiteAsyncConnection GetConnectionAsync()
        {
            const string fileName = "MyDB.db3";
            var documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
            var path = Path.Combine(documentsPath, fileName);

            var platform = new SQLitePlatformAndroid();

            var param = new SQLiteConnectionString(path, false); 
            var connection = new SQLiteAsyncConnection(() => new SQLiteConnectionWithLock(platform, param)); 

            return connection;
        }

answered May 11, 2015 at 1:52

rubStackOverflow

6,2632 gold badges34 silver badges44 bronze badges

Collectives™ on Stack Overflow

Xamarin.Forms using SQLite.Net.Async

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related