WPF-如何以编程方式备份​​还原LocalDB-ClickOnce

WPF-如何以编程方式备份​​/还原LocalDB-ClickOnce

这就是我对localDb进行备份和还原时所做的事情

public void BackupDatabase(string filePath)    {        using (TVend2014Entities dbEntities = new TVend2014Entities(baseData.ConnectionString))        { string backupQuery = @"BACKUP DATAbase ""{0}"" TO DISK = N'{1}'"; backupQuery = string.Format(backupQuery, "full databsase file path like C:tempDb.mdf", filePath); dbEntities.Database.SqlQuery<object>(backupQuery).ToList().FirstOrDefault();        }    }    public void RestoreDatabase(string filePath)    {        using (TVend2014Entities dbEntities = new TVend2014Entities(baseData.ConnectionString))        { string restoreQuery = @"USE [Master];     ALTER DATAbase ""{0}"" SET SINGLE_USER WITH ROLLBACK IMMEDIATE;    RESTORE DATAbase ""{0}"" FROM DISK='{1}' WITH REPLACE;    ALTER DATAbase ""{0}"" SET MULTI_USER;"; restoreQuery = string.Format(restoreQuery, "full db file path", filePath); var list = dbEntities.Database.SqlQuery<object>(restoreQuery).ToList(); var resut = list.FirstOrDefault();        }    }

希望这就是你想要的。