public static void Main(string[] args)
{
using (var database = new TemporarySqlDatabase("SampleApplication"))
{
database.Create();
var upgrader =
DeployChanges.To
.SqlDatabase(database.ConnectionString)
.WithScriptsEmbeddedInAssembly(Assembly.GetExecutingAssembly())
.LogToConsole()
.Build();
var result = upgrader.PerformUpgrade();
// Display the result
if (result.Successful)
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Success!");
Console.ReadKey();
}
else
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(result.Error);
Console.ReadKey();
Console.WriteLine("Failed!");
}
// Database will be deleted at this point
}
Console.ReadKey();
}
public static void Main(string[] args)
{
string instanceName = @"(local)";
// Uncomment the following line to run against sql local db instance.
// string instanceName = @"(localdb)\Projects";
using (var database = new TemporarySqlDatabase("SampleApplication", instanceName))
{
database.Create();
var upgradeEngineBuilder = DeployChanges.To
.SqlDatabase(database.ConnectionString, null) //null or "" for default schema for user
.WithScriptsEmbeddedInAssembly(Assembly.GetExecutingAssembly(), script =>
{
if (script.EndsWith("Script0006 - Transactions.sql"))
return !args.Any(a => "--noError".Equals(a, StringComparison.InvariantCultureIgnoreCase));
return true;
})
.LogToConsole();
if (args.Any(a => "--withTransaction".Equals(a, StringComparison.InvariantCultureIgnoreCase)))
upgradeEngineBuilder = upgradeEngineBuilder.WithTransaction();
else if (args.Any(a => "--withTransactionPerScript".Equals(a, StringComparison.InvariantCultureIgnoreCase)))
upgradeEngineBuilder = upgradeEngineBuilder.WithTransactionPerScript();
var upgrader = upgradeEngineBuilder.Build();
Console.WriteLine("Is upgrade required: " + upgrader.IsUpgradeRequired());
var result = upgrader.PerformUpgrade();
// Display the result
if (result.Successful)
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Success!");
}
else
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(result.Error);
Console.WriteLine("Failed!");
}
Console.ForegroundColor = ConsoleColor.White;
Console.WriteLine();
Console.WriteLine("Press any key to delete your database and continue");
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Try the --withTransaction or --withTransactionPerScript to see transaction support in action");
Console.WriteLine("--noError to exclude the broken script");
Console.ReadKey();
// Database will be deleted at this point
}
}
