--- trunk/AnywhereTS.DBSupport/SqlMdfConnector.cs 2012/07/13 21:10:26 85 +++ trunk/AnywhereTS.DBSupport/SqlMdfConnector.cs 2012/07/14 11:14:09 123 @@ -2,6 +2,8 @@ using System.Collections.Generic; using System.Text; using System.Data.SqlClient; +using Microsoft.SqlServer.Management.Common; +using Microsoft.SqlServer.Management.Smo; namespace AnywhereTS.DBSupport { @@ -15,12 +17,33 @@ namespace AnywhereTS.DBSupport try { string connetionString = null; - connetionString = string.Format(@"Data Source={0}\{1};;AttachDbFilename=|DataDirectory|\{2};Integrated Security=SSPI", DBServerAddress, DBServerInstance, DBDatabase); + connetionString = GetConnectionString(); connection = new SqlConnection(); connection.ConnectionString = connetionString; } //catch (SqlException ex) { Console.WriteLine(ex.ToString()); ErrorInfo = ex; throw ErrorInfo;} catch (Exception ex) { Console.WriteLine(ex.ToString()); ErrorInfo = ex; throw ErrorInfo; } } + + new public static string GetConnectionString() + { + return string.Format(@"Data Source={0}\{1};AttachDbFilename=|DataDirectory|\{2};Integrated Security=SSPI", DBServerAddress, DBServerInstance, DBDatabase); + } + + protected override bool ClientRunScript(string strFile, out Exception ErrorInfo) + { + ErrorInfo = null; + try + { + Server server = new Server(new ServerConnection(this.connection)); + server.ConnectionContext.ExecuteNonQuery(strFile); + return true; + } + catch (Exception ex) + { + ErrorInfo = ex; + return false; + } + } } } |