/[AnywhereTS-MSSQL]/trunk/AnywhereTS.DBSupport/SqlMdfConnector.cs
ViewVC logotype

Diff of /trunk/AnywhereTS.DBSupport/SqlMdfConnector.cs

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 89 by william, Fri Jul 13 22:56:50 2012 UTC revision 134 by william, Sun Jul 15 05:13:20 2012 UTC
# Line 2  Line 2 
2  using System.Collections.Generic;  using System.Collections.Generic;
3  using System.Text;  using System.Text;
4  using System.Data.SqlClient;  using System.Data.SqlClient;
5    using System.Linq;
6    using System.Text.RegularExpressions;
7  namespace AnywhereTS.DBSupport  namespace AnywhereTS.DBSupport
8  {  {
9      public class SqlMdfConnector : DBConnector<SqlParameter, SqlCommand, SqlConnection, SqlDataAdapter>      public class SqlMdfConnector : DBConnector<SqlParameter, SqlCommand, SqlConnection, SqlDataAdapter>
# Line 14  namespace AnywhereTS.DBSupport Line 15  namespace AnywhereTS.DBSupport
15              ErrorInfo = null;              ErrorInfo = null;
16              try              try
17              {              {
18                  string connetionString = null;                  string connetionString = GetConnectionString();
19                  connetionString = GetConnectionString();                  using (log4net.NDC.Push(string.Format("connetionString={0}", connetionString)))
20                  connection = new SqlConnection();                  {
21                  connection.ConnectionString = connetionString;                      Logging.DatabaseLog.Debug("Creating Connection");
22                        connection = new SqlConnection();
23                        connection.ConnectionString = connetionString;
24                        Logging.DatabaseLog.Debug("Created Connection");
25                    }
26              }              }
27              //catch (SqlException ex) { Console.WriteLine(ex.ToString()); ErrorInfo = ex;  throw ErrorInfo;}              //catch (SqlException ex) { Console.WriteLine(ex.ToString()); ErrorInfo = ex;  throw ErrorInfo;}
28              catch (Exception ex) { Console.WriteLine(ex.ToString()); ErrorInfo = ex; throw ErrorInfo; }              catch (Exception ex) { Console.WriteLine(ex.ToString()); ErrorInfo = ex; throw ErrorInfo; }
# Line 25  namespace AnywhereTS.DBSupport Line 30  namespace AnywhereTS.DBSupport
30    
31          new public static string GetConnectionString()          new public static string GetConnectionString()
32          {          {
33              return string.Format(@"Data Source={0}\{1};;AttachDbFilename=|DataDirectory|\{2};Integrated Security=SSPI", DBServerAddress, DBServerInstance, DBDatabase);              return string.Format(@"Data Source={0}\{1};AttachDbFilename=|DataDirectory|\{2};Integrated Security=SSPI", DBServerAddress, DBServerInstance, DBDatabase);
34            }
35    
36            protected override bool ClientRunScript(string strFile, out Exception ErrorInfo)
37            {
38                ErrorInfo = null;
39                try
40                {
41                    var commands = Regex.Split(strFile, string.Format(@"^GO{0}", System.Environment.NewLine), RegexOptions.IgnoreCase | RegexOptions.Multiline);
42                    foreach (var command in commands)
43                    {
44                        Logging.DatabaseLog.DebugFormat("Current Command={0}", command);
45                        SqlConnection sqlCon;
46                        this.GetConnectionClone(out sqlCon, out ErrorInfo);
47                        SqlCommand sqlcmd = new SqlCommand(command, this.connection);
48                        sqlcmd.CommandText = command;
49                        sqlcmd.Connection = sqlCon;
50                        sqlcmd.CommandType = System.Data.CommandType.Text;
51                        sqlcmd.ExecuteNonQuery();
52                    }
53                    return true;
54                }
55                catch (Exception ex)
56                {
57                    ErrorInfo = ex;
58                    throw ErrorInfo;
59                }
60          }          }
61      }      }
62  }  }

Legend:
Removed from v.89  
changed lines
  Added in v.134

  ViewVC Help
Powered by ViewVC 1.1.22