private void Backup() { string content = this._buttonBackup.Content.ToString(); this._buttonBackup.Content = "正在备份..."; this._buttonBackup.UpdateUIEvents(); string dirPath = string.Format(@"{0}\backup", System.Windows.Forms.Application.StartupPath); if (!Directory.Exists(dirPath)) { Directory.CreateDirectory(dirPath); } string bakPath = string.Format(@"{0}\Statement.{1}.bak", dirPath, DateTime.Now.ToString("yyyyMMdd.HHmmss")); var conn = new StatementContext().Database.Connection; var cmd = conn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = string.Format("BACKUP DATABASE Statement TO DISK ='{0}'", bakPath); try { conn.Open(); cmd.ExecuteNonQuery(); MessageBox.Show(string.Format("数据已备份至\n\"{0}\"", bakPath)); } catch (Exception ex) { MessageBox.Show(ex.Message + "\n" + ex.StackTrace); } finally { conn.Close(); this._buttonBackup.Content = content; } }