UserProfile.Department = txtDepartment.Text Īwait SQLiteDataAccess.InsertAsync(userProfile) Get/Set the DB version with this constant value and make the appropriate DB changesĪs implemented in UpgradeDatabaseIfNecessary() method. Releasing a new app version where you have few db schema changes. In this, define a constant with current db version, increment this value whenever UpgradeDatabaseIfNecessary() is a method to make data base table changes (CRUD) whenever upgrading to new app private static async void SetDatabaseToVersion(int version)Īwait DataBase.ExecuteAsync( 'PRAGMA user_version = ' + version) įrom above, CreateTables() is a method to create all data base tables. public interface ISQLiteĬlass implementation as Dependency Service in UWP project as below. Phone 8.1 and Microsoft Visual C++ 2013 runtime package for windows phone inĬreate a new interface ISQLite in PCL to abstract the platform specific functionality. If you are using Windows Phone 8.1 project, install the extension SQLite for Windows CreateĪ Xamarin forms application and add the sql-net-pcl nuget package version 1.2.1 Platform-specific projects returning a path to where the database will be stored.

In the Portable Class Library (PCL) project of the Xamarin.Forms solution, with The SQLite classes that ship in the NuGet. Xamarin Forms applications can use the sqlite-net-pcl NuGet package to incorporate data base operations in to shared code by referencing

Xamarin forms sqlite