2004-08-13 Umadevi S <sumadevi@novell.com>

        * Added standalone nunit testcases for datacontainer class.
        * Currently will use MSSQL server
        * New File
                MSSqlTestBed.cs - Base class for MSSql testing
        (similar to the mysqltestbed)

svn path=/branches/mono-1-0/mcs/; revision=32296

2 files changed, 107 insertions, 0 deletions

diff --git a/mcs/class/System.Data/Test/ChangeLog b/mcs/class/System.Data/Test/ChangeLog
index 49630c2d5d8..f519b6dce99 100644
--- a/mcs/class/System.Data/Test/ChangeLog
+++ b/mcs/class/System.Data/Test/ChangeLog
@@ -1,3 +1,10 @@
+2004-08-13 Umadevi S <sumadevi@novell.com>
+	* Added standalone nunit testcases for datacontainer class.
+	* Currently will use MSSQL server
+	* New File
+		MSSqlTestBed.cs - Base class for MSSql testing
+	(similar to the mysqltestbed)
+
 2004-06-16  Sureshkumar T <TSureshkumar@novell.com>
 	* Added standalone NUnit test cases for MySql db related tests.
 	* Created sub-directory for System.Data.Odbc
diff --git a/mcs/class/System.Data/Test/MSSqlTestBed.cs b/mcs/class/System.Data/Test/MSSqlTestBed.cs
new file mode 100644
index 00000000000..bb2ed3bd160
--- /dev/null
+++ b/mcs/class/System.Data/Test/MSSqlTestBed.cs
@@ -0,0 +1,100 @@
+//
+// MSSqlTestBed.cs : This is base class which manages the connections to 
+//                    MSSql database. This serves as a base class for all
+//		      MSSql database dependant tests.
+//
+// To run :
+//  
+//  * compile using following command
+//      mcs /r:System.Data.dll,nunit.framework.dll /t:library /debug
+//      /out:MSSqlTestBed.dll MSSqlTestBed.cs System.Data.Common/*.cs
+//  * To run the tests
+//      mono /usr/local/bin/nunit-console.exe MSSqlTestBed.dll
+//
+// Author:
+//      Umadevi S (sumadevi@novell.com)
+//
+// Copyright (c) 2004 Novell Inc., and the individuals listed
+// on the ChangeLog entries.
+// 
+// Permission is hereby granted, free of charge, to any person obtaining
+// a copy of this software and associated documentation files (the
+// "Software"), to deal in the Software without restriction, including
+// without limitation the rights to use, copy, modify, merge, publish,
+// distribute, sublicense, and/or sell copies of the Software, and to
+// permit persons to whom the Software is furnished to do so, subject to
+// the following conditions:
+// 
+// The above copyright notice and this permission notice shall be
+// included in all copies or substantial portions of the Software.
+// 
+// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
+// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
+// MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
+// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
+// LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
+// OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
+// WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
+//
+
+using System;
+using System.Data;
+using System.Data.Common;
+using System.Data.SqlClient;
+using System.Collections.Specialized;
+
+namespace MonoTests.System.Data 
+{
+        public class MSSqlTestClient  
+        {
+                #region protected members
+                protected string connectionString = null;
+                protected SqlConnection conn = null;
+                protected bool isConnAlive = false;
+                #endregion
+
+                public MSSqlTestClient ()
+                {
+				connectionString =
+                                        "Server=164.99.168.131;" +
+                                        "Database=Northwind;" +
+                                        "User ID=sa;" +
+                                        "Password=novell";
+                                conn = new SqlConnection(connectionString);
+                }
+
+                protected void OpenConnection () 
+                {
+		        conn.ConnectionString = connectionString;
+                        conn.Open ();
+                        // run tests only if the connection is open,
+                        // otherwise make it fail, to setup with correct
+                        // database settings
+                        if (conn != null && conn.State != ConnectionState.Closed) 
+                                isConnAlive = true;
+                }
+
+                protected void CloseConnection () 
+                {
+                        if (conn != null && conn.State != ConnectionState.Closed) {
+                                conn.Close ();
+                                isConnAlive = false;
+                        }
+                }
+
+		internal void ExecuteQuery (string query)
+                {
+                        SqlCommand cmd = new SqlCommand ();
+                        cmd.Connection = conn;
+                        cmd.CommandText = query;
+                        try {
+                                int recordsAff = cmd.ExecuteNonQuery ();
+                        } catch (Exception e) {
+				Console.WriteLine("exception");
+				Console.WriteLine(e.StackTrace);
+                        }
+                }
+	
+
+        }
+}