When using sqlite-net-pcl with Xamarin.Forms what are best practices for create connection

Question

I'm using SQLite-Net-Pcl in Xamarin.Forms application, I have created a singleton dataStore class for all my database methods. What is the best practice for creating a SQLiteConnection? Should there be a private readonly connection object on your class and use it in all your db operations. Or should you use create a new SQLiteConnection in every method? Also should I use a lock() statement around my db code?

lock(lockerObj)
{ 
  // db code 
}

You could check the code sample in the link below. docs.microsoft.com/en-us/xamarin/get-started/quickstarts/… — Wendy Zang - MSFT

webwires webwires · Accepted Answer · 2021-04-01T19:48:50

That depends a lot on the nature of your data and the nature / complexity of your application.

For us we have had no issues using a single connection and using the lock statement to help ensure serialized updates to the database. That is the simplest to implement and manage since you don't need to be concerned with connection isolation.

But that is not a one size fits all solution.

When using sqlite-net-pcl with Xamarin.Forms what are best practices for create connection

1 Answers