private void SetVersion(int version) { using (var con = SqlServerTools.OpenConnection()) { con.ExecuteNonQuery("UPDATE DatabaseSchema SET Version = @version", new { version = version }); } }
private void DropSchemaTable() { using (var con = SqlServerTools.OpenConnection()) { con.ExecuteNonQuery(@"DROP TABLE [dbo].[DatabaseSchema]"); } }
private void EnsureSchemaTable() { using (var con = SqlServerTools.OpenConnection()) { con.ExecuteNonQuery(@" IF OBJECT_ID(N'dbo.[DatabaseSchema]', N'U') IS NULL BEGIN CREATE TABLE [dbo].[DatabaseSchema] ( [Version] int not null default 1 ); INSERT INTO DatabaseSchema VALUES(1); END "); } }