private static void Update001() { using (var repository = new CountryRepository(DatabaseSourceDefinitor.ConnectionString)) { repository.CreateItem(new Country { Id = 250, Code = "FRA", Name = "France" }); } using (IDbConnection connection = new SQLiteConnection(DatabaseSourceDefinitor.ConnectionString)) { connection.Execute("update DbInfo set Version = 1"); } }
private static void Update002() { using (var repository = new CountryRepository(DatabaseSourceDefinitor.ConnectionString)) { repository.CreateItem(new Country { Id = 4401, Code = "ENG", Name = "England" }); repository.CreateItem(new Country { Id = 49, Code = "GER", Name = "Germany" }); repository.CreateItem(new Country { Id = 39, Code = "ITA", Name = "Italy" }); } using (IDbConnection connection = new SQLiteConnection(DatabaseSourceDefinitor.ConnectionString)) { connection.Execute("update DbInfo set Version = 2"); } }