/[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 130 by william, Sat Jul 14 13:16:38 2012 UTC revision 134 by william, Sun Jul 15 05:13:20 2012 UTC
# Line 15  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 38  namespace AnywhereTS.DBSupport Line 42  namespace AnywhereTS.DBSupport
42                  foreach (var command in commands)                  foreach (var command in commands)
43                  {                  {
44                      Logging.DatabaseLog.DebugFormat("Current Command={0}", command);                      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);                      SqlCommand sqlcmd = new SqlCommand(command, this.connection);
48                        sqlcmd.CommandText = command;
49                        sqlcmd.Connection = sqlCon;
50                      sqlcmd.CommandType = System.Data.CommandType.Text;                      sqlcmd.CommandType = System.Data.CommandType.Text;
                     if (ErrorInfo != null)  
                         throw ErrorInfo;  
51                      sqlcmd.ExecuteNonQuery();                      sqlcmd.ExecuteNonQuery();
52                  }                  }
53                  return true;                  return true;
# Line 49  namespace AnywhereTS.DBSupport Line 55  namespace AnywhereTS.DBSupport
55              catch (Exception ex)              catch (Exception ex)
56              {              {
57                  ErrorInfo = ex;                  ErrorInfo = ex;
58                  return false;                  throw ErrorInfo;
59              }              }
60          }          }
61      }      }

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

  ViewVC Help
Powered by ViewVC 1.1.22