public void LogMigration(string filename, MigrationDirectionEnum direction)
{
StringBuilder recordMigrationSQL =
new StringBuilder(string.Format(
@"IF NOT EXISTS (SELECT * FROM migrator.VersionInfo WHERE MigrationFilename = N'{0}')
BEGIN
INSERT INTO migrator.VersionInfo (MigrationFilename, DateTimeApplied, Direction)
VALUES (N'{0}', CAST(N'{1}' AS DATETIME), N'{2}');
END
ELSE
BEGIN
UPDATE migrator.VersionInfo
SET MigrationFilename = N'{0}', DateTimeApplied = CAST(N'{1}' AS DATETIME), Direction = N'{2}'
WHERE MigrationFilename = N'{0}'
END
",
filename.ToString(),
DateTime.Now.ToString("dd MMM yyyy HH:mm:ss"),
direction.ToString().ToUpper()[0]));
runSQLcommand(recordMigrationSQL);
}
