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

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

Parent Directory Parent Directory | Revision Log Revision Log


Revision 89 - (show annotations) (download)
Fri Jul 13 22:56:50 2012 UTC (8 years, 7 months ago) by william
File size: 1279 byte(s)
+ fix compile errors
+ add ability to get Connection string (made it static)

1 using System;
2 using System.Collections.Generic;
3 using System.Text;
4 using System.Data.SqlClient;
5
6 namespace AnywhereTS.DBSupport
7 {
8 public class SqlMdfConnector : DBConnector<SqlParameter, SqlCommand, SqlConnection, SqlDataAdapter>
9 {
10 public SqlMdfConnector(string DBServerAddress, string DBServerInstance, string SqlMdf) : base(DBServerAddress, DBServerInstance, SqlMdf) { }
11
12 public override void CreateConnection(out Exception ErrorInfo)
13 {
14 ErrorInfo = null;
15 try
16 {
17 string connetionString = null;
18 connetionString = GetConnectionString();
19 connection = new SqlConnection();
20 connection.ConnectionString = connetionString;
21 }
22 //catch (SqlException ex) { Console.WriteLine(ex.ToString()); ErrorInfo = ex; throw ErrorInfo;}
23 catch (Exception ex) { Console.WriteLine(ex.ToString()); ErrorInfo = ex; throw ErrorInfo; }
24 }
25
26 new public static string GetConnectionString()
27 {
28 return string.Format(@"Data Source={0}\{1};;AttachDbFilename=|DataDirectory|\{2};Integrated Security=SSPI", DBServerAddress, DBServerInstance, DBDatabase);
29 }
30 }
31 }

  ViewVC Help
Powered by ViewVC 1.1.22