c# - 如何使用 C#-WPF-Entity-Framework Code First 应用程序创建数据库备份？

Question

我首先使用实体​​框架代码开发桌面应用程序，我需要在某个时候使用按钮单击事件在数据库上创建备份。我使用的是 Entity-Framework 版本 6.1.3，Visual Studio 2013 Ultimate。

Answer 1

虽然您不需要 EF 来执行备份/恢复，但这是来自 here 的代码片段.阅读完整文章以了解详细信息和要求。

public static void BackupDatabase(string backUpFile)
    {
    ServerConnection con = new ServerConnection(@"xxxxx\SQLEXPRESS");
    Server server = new Server(con);
    Backup source = new Backup();
    source.Action = BackupActionType.Database;
    source.Database = "MyDataBaseName";
    BackupDeviceItem destination = new BackupDeviceItem(backUpFile, DeviceType.File);
    source.Devices.Add(destination);
    source.SqlBackup(server);
    con.Disconnect();
    }

public static void RestoreDatabase(string backUpFile)
    {
    ServerConnection con = new ServerConnection(@"xxxxx\SQLEXPRESS");
    Server server = new Server(con);
    Restore destination = new Restore();
    destination.Action = RestoreActionType.Database;
    destination.Database = "MyDataBaseName";
    BackupDeviceItem source = new BackupDeviceItem(backUpFile, DeviceType.File);
    destination.Devices.Add(source);
    destination.ReplaceDatabase = true;
    destination.SqlRestore(server);
    }