public void CheckDatabaseVersion()
{
upgradeEngine = DeployChanges.To
.SqlDatabase(ConnectionInfo.ConnectionString)
.WithScriptsEmbeddedInAssembly(this.GetType().Assembly)
.LogToConsole()
.Build();
IsUpgradeRequired = upgradeEngine.IsUpgradeRequired();
if (IsUpgradeRequired.HasValue && IsUpgradeRequired.Value == false)
{
Status = DatabaseHelperStatusEnum.CelsusDatabaseVersionOk;
}
if (IsUpgradeRequired.HasValue && IsUpgradeRequired.Value == true)
{
Status = DatabaseHelperStatusEnum.CelsusDatabaseVersionOld;
}
//var tr=upgradeEngine.GetScriptsToExecute();
}
static int Main(string[] args)
{
string connectionString = ConfigurationManager.ConnectionStrings["DbConnection"].ConnectionString;
UpgradeEngine engine =
DeployChanges.To
.SqlDatabase(connectionString)
.WithScriptsEmbeddedInAssembly(Assembly.GetExecutingAssembly())
.LogToConsole()
.Build();
if (!engine.IsUpgradeRequired())
{
Console.WriteLine("No upgrade required, database is already up to date.");
return(0);
}
return(PerformUpgrade(engine));
}
void WhenCheckIfDatabaseUpgradeIsRequired()
{
upgradeEngine = upgradeEngineBuilder.Build();
isUpgradeRequired = upgradeEngine.IsUpgradeRequired();
}
public bool IsUpgradeRequired() => _upgradeEngine.IsUpgradeRequired();
private static int Main(string[] args)
{
bool debug = (args.Length != 0);
var folderPath = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\MeetTracker";
try
{
Directory.CreateDirectory(folderPath);
}
catch (IOException e)
{
Console.WriteLine("Could not create path : {0}", e.ToString());
folderPath = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData);
}
var connectionString = "Data Source=" + folderPath + "\\meet.db; Version=3";
UpgradeEngine upgrader = null;
try
{
upgrader =
DeployChanges.To
.SQLiteDatabase(connectionString)
.WithScriptsEmbeddedInAssembly(Assembly.GetExecutingAssembly())
.LogToConsole()
.Build();
}
catch (Exception e)
{
Console.WriteLine(e);
return(-1);
}
if (!upgrader.IsUpgradeRequired())
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Success!");
Console.ResetColor();
if (debug)
{
Console.ReadKey();
}
return(0);
}
DatabaseUpgradeResult result = null;
try
{
result = upgrader.PerformUpgrade();
}
catch (Exception e)
{
Console.WriteLine(e);
if (!result.Successful)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(result.Error);
Console.ResetColor();
if (debug)
{
Console.ReadKey();
}
return(-1);
}
}
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine(connectionString);
Console.WriteLine("Success!");
Console.ResetColor();
if (debug)
{
Console.ReadKey();
}
return(0);
}