trunk/AnywhereTS.DBSupport/SqlMdfConnector.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;

namespace AnywhereTS.DBSupport
{
    public class SqlMdfConnector : DBConnector<SqlParameter, SqlCommand, SqlConnection, SqlDataAdapter>
    {        
        public SqlMdfConnector(string DBServerAddress, string DBServerInstance, string SqlMdf) : base(DBServerAddress, DBServerInstance, SqlMdf) { }

        public override void CreateConnection(out Exception ErrorInfo)
        {
            ErrorInfo = null;
            try
            {
                string connetionString = null;
                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);
        }
    }
}
Revision:	89
Committed:	Fri Jul 13 22:56:50 2012 UTC (11 years, 2 months ago) by william
File size:	1279 byte(s)
Log Message:	+ fix compile errors + add ability to get Connection string (made it static)
#	Content
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	}