using System; using System.Data; using System.Data.SqlClient;
namespace Util { class DbHelper { public static string DbName { get; set; }
private static SqlConnection SqlConnection = new SqlConnection("data source=.;Initial Catalog=master;integrated security=SSPI;"); private static string SqlBackup = "BACKUP DATABASE BookShop TO DISK = 'F:\\ms\\src\\InternetBookstore\\DB\\" + DbName + ".bak'"; private static string SqlRestore = "Alter database BookShop Set Offline With rollback immediate RESTORE DATABASE BookShop FROM DISK = 'F:\\ms\\src\\InternetBookstore\\DB\\" + DbName + ".bak' Alter database BookShop Set Online With Rollback immediate"; private SqlCommand SqlCommandBackup = new SqlCommand() { Connection = SqlConnection, CommandType = CommandType.Text, CommandText = SqlBackup }; private SqlCommand SqlCommandRestore = new SqlCommand() { Connection = SqlConnection, CommandType = CommandType.Text, CommandText = SqlRestore };
public void DbBackup() { SqlConnection.Open(); try { SqlCommandBackup.ExecuteNonQuery(); } catch (Exception e) { string str = e.Message; SqlConnection.Close(); } SqlConnection.Close(); }
public void DbRestore() { SqlConnection.Open(); try { SqlCommandRestore.ExecuteNonQuery(); } catch (Exception e) { string str = e.Message; SqlConnection.Close(); } SqlConnection.Close(); } } }
