ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/AnywhereTS-MSSQL/trunk/AnywhereTS.DBSupport/SqlMdfConnector.cs
(Generate patch)

Comparing trunk/AnywhereTS.DBSupport/SqlMdfConnector.cs (file contents):
Revision 85 by william, Fri Jul 13 21:10:26 2012 UTC vs.
Revision 119 by william, Sat Jul 14 09:08:55 2012 UTC

--- 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;
+            }
+        }
     }
 }