/[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 85 by william, Fri Jul 13 21:10:26 2012 UTC revision 130 by william, Sat Jul 14 13:16:38 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 15  namespace AnywhereTS.DBSupport Line 16  namespace AnywhereTS.DBSupport
16              try              try
17              {              {
18                  string connetionString = null;                  string connetionString = null;
19                  connetionString = string.Format(@"Data Source={0}\{1};;AttachDbFilename=|DataDirectory|\{2};Integrated Security=SSPI", DBServerAddress, DBServerInstance, DBDatabase);                  connetionString = GetConnectionString();
20                  connection = new SqlConnection();                  connection = new SqlConnection();
21                  connection.ConnectionString = connetionString;                  connection.ConnectionString = connetionString;
22              }              }
23              //catch (SqlException ex) { Console.WriteLine(ex.ToString()); ErrorInfo = ex;  throw ErrorInfo;}              //catch (SqlException ex) { Console.WriteLine(ex.ToString()); ErrorInfo = ex;  throw ErrorInfo;}
24              catch (Exception ex) { Console.WriteLine(ex.ToString()); ErrorInfo = ex; throw ErrorInfo; }              catch (Exception ex) { Console.WriteLine(ex.ToString()); ErrorInfo = ex; throw ErrorInfo; }
25          }          }
26    
27            new public static string GetConnectionString()
28            {
29                return string.Format(@"Data Source={0}\{1};AttachDbFilename=|DataDirectory|\{2};Integrated Security=SSPI", DBServerAddress, DBServerInstance, DBDatabase);
30            }
31    
32            protected override bool ClientRunScript(string strFile, out Exception ErrorInfo)
33            {
34                ErrorInfo = null;
35                try
36                {
37                    var commands = Regex.Split(strFile, string.Format(@"^GO{0}", System.Environment.NewLine), RegexOptions.IgnoreCase | RegexOptions.Multiline);
38                    foreach (var command in commands)
39                    {
40                        Logging.DatabaseLog.DebugFormat("Current Command={0}", command);
41                        SqlCommand sqlcmd = new SqlCommand(command, this.connection);
42                        sqlcmd.CommandType = System.Data.CommandType.Text;
43                        if (ErrorInfo != null)
44                            throw ErrorInfo;
45                        sqlcmd.ExecuteNonQuery();
46                    }
47                    return true;
48                }
49                catch (Exception ex)
50                {
51                    ErrorInfo = ex;
52                    return false;
53                }
54            }
55      }      }
56  }  }

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

  ViewVC Help
Powered by ViewVC 1.1.22