/// <summary> /// Method to create the tables required by this classs /// </summary> private void CreateDatabases() { // Drop tables //DatabaseAsyncConnection.DropTableAsync<LocationModel>(); //DatabaseAsyncConnection.DropTableAsync<ItemPriceLocationModel>(); // Create tables if they don't already exist DatabaseAsyncConnection.CreateTableAsync <LocationModel>(SQLite.CreateFlags.ImplicitPK | SQLite.CreateFlags.AutoIncPK).Wait(); DatabaseAsyncConnection.CreateTableAsync <ItemPriceLocationModel>(SQLite.CreateFlags.ImplicitPK | SQLite.CreateFlags.AutoIncPK).Wait(); }
/// <summary> /// Method to create the required database tables /// </summary> private void CreateDatabases() { // Drop the tables //DatabaseAsyncConnection.DropTableAsync<ShoppingListModel>(); //DatabaseAsyncConnection.DropTableAsync<ItemQuantityPairModel>(); //DatabaseAsyncConnection.DropTableAsync<ListOwnerModel>(); // Create the tables if necessary DatabaseAsyncConnection.CreateTableAsync <LocationModel>(SQLite.CreateFlags.ImplicitPK | SQLite.CreateFlags.AutoIncPK).Wait(); DatabaseAsyncConnection.CreateTableAsync <ShoppingListModel>(SQLite.CreateFlags.ImplicitPK | SQLite.CreateFlags.AutoIncPK).Wait(); DatabaseAsyncConnection.CreateTableAsync <ItemQuantityPairModel>(SQLite.CreateFlags.ImplicitPK | SQLite.CreateFlags.AutoIncPK).Wait(); DatabaseAsyncConnection.CreateTableAsync <ListOwnerModel>(SQLite.CreateFlags.ImplicitPK | SQLite.CreateFlags.AutoIncPK).Wait(); }