diff options
author | Umadevi S <uma@mono-cvs.ximian.com> | 2004-08-13 10:59:30 +0400 |
---|---|---|
committer | Umadevi S <uma@mono-cvs.ximian.com> | 2004-08-13 10:59:30 +0400 |
commit | 098549da23b7ffb89ee7a1a668bc19cdc74b09c7 (patch) | |
tree | c9175f56e5e9e3e27874e5a9f246e7986313423d /mcs | |
parent | e91035e48e6b5914866063e4b8bc4e4c02507b29 (diff) |
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
Diffstat (limited to 'mcs')
-rw-r--r-- | mcs/class/System.Data/Test/ChangeLog | 7 | ||||
-rw-r--r-- | mcs/class/System.Data/Test/MSSqlTestBed.cs | 100 |
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); + } + } + + + } +} |