BLL/DataBaseOperation.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;

namespace BLL
{
   /// <summary>
   /// 数据库操作类，包括备份和还原数据库等操作
   /// </summary>
    public class DataBaseOperation
    {
        public string ErrorMessage = "";
        /// <summary>
        /// 备份整个数据库
        /// </summary>
        /// <param name="dataBase">数据库</param>
        /// <param name="dir">路径</param>
        /// <returns></returns>
        public int backAllDataBase(string dataBase,string dir)
        {
            int flag = 0;
            string SqlStr2 = "backup database " +
           dataBase + " to disk='" +
           dir + ".bak'";   
            return flag;
        }
    }
}