It’s IMPORTANT to notice that you MUST create in your code the SAME models already present in your database). It means that you should copy your existing db from the assets folder to that folder and after that, you can easily use the plugin.Īs this database could be incompatible (I doubt it but of course I cannot be sure),I’d suggest you to do a backup of it before you try to use it with the plugin. The only thing to notice is that this plugin saves (and loads) the database from the “” folder which should be

It’s possible to use my plugin with a prebuilt database. And this is exactly what we get launching the app on UWP. If everything works as expected we should see inside the text “Rows:3” on screen. Label1.Text = 'Rows:' + conn.Table().Count() Īs you can see in the image after we obtain a connection to the database, we can create a table and add some elements to it. This in case you want to use an async connection SQLiteConnection conn = ('YOURDBNAME.db3') InitializeComponent() //The only line you need to create your database. Public partial class MainPage : ContentPage Remember to replace the string with the name you want for your database.

Inside the MainPage constructor you can see that the only line of code you need to create your database and open a connection to it is SQLiteConnection conn = ('YOURDBNAME.db3') Now it’s time to try the plugin to see how easy it is.

Xamarin forms sqlite