trunk/AnywhereTS.DBSupport/MSSQLConnector.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using Microsoft.SqlServer.Management.Common;
using Microsoft.SqlServer.Management.Smo;

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


        protected override bool ClientRunScript(string strFile, out Exception ErrorInfo)
        {
            ErrorInfo = null;
            try
            {
                Server server = new Server(new ServerConnection(this.connection));
                server.ConnectionContext.ExecuteNonQuery(strFile);
                return true;
            }
            catch (Exception ex)
            {
                ErrorInfo = ex;
                return false;
            }
        }
    }
}
Revision:	123
Committed:	Sat Jul 14 11:14:09 2012 UTC (10 years, 10 months ago) by william
File size:	1008 byte(s)
Log Message:	+ bulk commit -- add SQLSerer SMO support for executing TSQL commands
#	Content
1	using System;
2	using System.Collections.Generic;
3	using System.Text;
4	using System.Data.SqlClient;
5	using Microsoft.SqlServer.Management.Common;
6	using Microsoft.SqlServer.Management.Smo;
7
8	namespace AnywhereTS.DBSupport
9	{
10	public class MsSqlConnector : DBConnector<SqlParameter,SqlCommand,SqlConnection,SqlDataAdapter>
11	{
12	public MsSqlConnector(string DBServerAddress, string DBServerInstance, string DBDatabase) : base(DBServerAddress, DBServerInstance, DBDatabase) { }
13
14
15	protected override bool ClientRunScript(string strFile, out Exception ErrorInfo)
16	{
17	ErrorInfo = null;
18	try
19	{
20	Server server = new Server(new ServerConnection(this.connection));
21	server.ConnectionContext.ExecuteNonQuery(strFile);
22	return true;
23	}
24	catch (Exception ex)
25	{
26	ErrorInfo = ex;
27	return false;
28	}
29	}
30	}
31	}