--- trunk/AnywhereTS.DBSupport/SqlMdfConnector.cs 2012/07/13 21:10:26 85 +++ trunk/AnywhereTS.DBSupport/SqlMdfConnector.cs 2012/07/14 09:08:55 119 @@ -15,12 +15,41 @@ 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); + } + + public override bool ClientRunScript(string[] strCommands, out Exception ErrorInfo) + { + ErrorInfo = null; + try + { + foreach (string strCmd in strCommands) + { + if (strCmd.Length > 0) + { + Logging.DatabaseLog.DebugFormat("Current Command: {0}{1}", System.Environment.NewLine, strCmd); + // Substitute database directory with the decided one. + SqlCommand command = this.CreateCommandInstance(strCmd, new List<SqlParameter>(), out ErrorInfo); + command.ExecuteNonQuery(); + } + } + return true; + } + catch (Exception ex) + { + ErrorInfo = ex; + return false; + } + } } } |