trunk/AnywhereTS.DBSupport/MSSQLConnector.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Linq;
using System.Text.RegularExpressions;
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
            {
                var commands = Regex.Split(strFile, string.Format(@"^GO${0}", System.Environment.NewLine), RegexOptions.IgnoreCase | RegexOptions.Multiline);
                foreach (var command in commands)
                {
                    SqlCommand sqlcmd = this.CreateCommandInstance(command, new List<SqlParameter>(), out ErrorInfo);
                    if (ErrorInfo != null)
                        throw ErrorInfo;
                    sqlcmd.ExecuteNonQuery();
                }
                return true;
            }
            catch (Exception ex)
            {
                ErrorInfo = ex;
                return false;
            }
        }
    }
}
Revision:	125
Committed:	Sat Jul 14 11:44:52 2012 UTC (10 years, 6 months ago) by william
File size:	1324 byte(s)
Log Message:	+ remove reference to Sql Server SMO components + attempt to fix .sql script parsing to split on GO statements
#	Content
1	using System;
2	using System.Collections.Generic;
3	using System.Text;
4	using System.Data.SqlClient;
5	using System.Linq;
6	using System.Text.RegularExpressions;
7	namespace AnywhereTS.DBSupport
8	{
9	public class MsSqlConnector : DBConnector<SqlParameter,SqlCommand,SqlConnection,SqlDataAdapter>
10	{
11	public MsSqlConnector(string DBServerAddress, string DBServerInstance, string DBDatabase) : base(DBServerAddress, DBServerInstance, DBDatabase) { }
12
13
14	protected override bool ClientRunScript(string strFile, out Exception ErrorInfo)
15	{
16	ErrorInfo = null;
17	try
18	{
19	var commands = Regex.Split(strFile, string.Format(@"^GO${0}", System.Environment.NewLine), RegexOptions.IgnoreCase \| RegexOptions.Multiline);
20	foreach (var command in commands)
21	{
22	SqlCommand sqlcmd = this.CreateCommandInstance(command, new List<SqlParameter>(), out ErrorInfo);
23	if (ErrorInfo != null)
24	throw ErrorInfo;
25	sqlcmd.ExecuteNonQuery();
26	}
27	return true;
28	}
29	catch (Exception ex)
30	{
31	ErrorInfo = ex;
32	return false;
33	}
34	}
35	}
36	}