34,593
社区成员
发帖
与我相关
我的任务
分享
var session = Z.Core.NHibernateCore.NHibernateHelper.GetCurrentSession();
var queryKill = session.CreateSQLQuery("USE Master; SELECT spid FROM sysprocesses ,sysdatabases WHERE sysprocesses.dbid=sysdatabases.dbid AND sysdatabases.Name='ZShop'");
var list = queryKill.List();
foreach (var item in list)
{
queryKill = session.CreateSQLQuery("KILL " + item);
queryKill.ExecuteUpdate();
}
var query = session.CreateSQLQuery("USE Master; RESTORE DATABASE ZSHOP FROM DISK ='" + filePath + fileName + "' WITH REPLACE");
query.ExecuteUpdate();