protected override void RunCore(IDbAccesser db)
{
bool isSqlceCon = CreateDbMigrationRun.IsSqlceConnection(db);
if (!isSqlceCon)
{
throw new InvalidOperationException("需要使用 SqlCe 的连接，才能正确创建数据库。");
}
File.Delete(db.Connection.Database);
}
private void CreateDb()
{
var action = new CreateDbMigrationRun();
action.Run(_db);
_db.RawAccesser.ExecuteText(@"
CREATE TABLE [Entities] (
[Region] nvarchar(100) NOT NULL,
[Key] nvarchar(100) NOT NULL,
[ChangeChecker] varbinary(8000) NULL,
[Time] datetime NOT NULL,
[ValuePath] nvarchar(1000) NULL,
[Value] varbinary(8000) NULL
);
");
_db.RawAccesser.ExecuteText(@"
ALTER TABLE [Entities] ADD CONSTRAINT [PK__Entities__000000000000000D] PRIMARY KEY ([Region],[Key]);");
}
