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
");
}
}
