public void GenerateScriptTest()
{
var dbConnection = DbConnection.From(modelConnection, "unemployment");
var service = new DbUpgradeService(dbConnection);
var dacpac = service.GenerateDacPac();
var script = service.GenerateUpgradeScript(dacpac, DbUpgradeOptions.From(ObjectType.Users, ObjectType.Views, ObjectType.RoleMembership, ObjectType.Permissions, ObjectType.ExtendedProperties, ObjectType.StoredProcedures, ObjectType.Logins, ObjectType.DatabaseTriggers, ObjectType.ServerTriggers), "newdb");
Assert.IsNotNull(script);
}
public void GenerateDacPacTest()
{
var dbConnection = DbConnection.From(modelConnection, "unemployment");
var service = new DbUpgradeService(dbConnection);
var result = service.GenerateDacPac();
var fileName = $"{Guid.NewGuid()}.dacpac";
File.WriteAllBytes(fileName, result);
Assert.IsNotNull(result);
Assert.IsTrue(File.Exists(fileName));
}
public ActionResult GenerateDacPac(DacPacModel model)
{
if (ModelState.IsValid)
{
var upgradeService = new DbUpgradeService(DbConnection.From(model.ConnectionString, model.DatabaseName));
var dacpacFile = upgradeService.GenerateDacPac();
var stream = new MemoryStream(dacpacFile);
return(File(stream, "application/octet-stream", $"{model.DatabaseName}.dacpac"));
}
return(View());
}