public ActionResult RestoreDatabase()
{
var dbPath = Server.MapPath("~/App_Data/DBBackup.bak");
using (var db = new EJIntegralDBEntities())
{
var cmd = $"USE master restore DATABASE {"EJIntegralDB"} from DISK='{dbPath}' WITH REPLACE;";
db.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction, cmd);
}
return(View());
}
// GET: Backup
public ActionResult BackupDatabase()
{
var dbPath = Server.MapPath("~/App_Data/DBBackup.bak");
using (var db = new EJIntegralDBEntities())
{
var cmd = $"BACKUP DATABASE {"EJIntegralDB"} TO DISK='{dbPath}' WITH FORMAT, MEDIANAME='DbBackups', MEDIADESCRIPTION='Media set for {"EJIntegralDB"} database';";
db.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction, cmd);
}
return(new FilePathResult(dbPath, "application/octet-stream"));
}
