2004-09-02 Umadevi S <sumadevi@novell.com>

	* Added file SqlDataReaderTest.cs

svn path=/trunk/mcs/; revision=33191

2 files changed, 96 insertions, 0 deletions

diff --git a/mcs/class/System.Data/Test/System.Data.SqlClient/ChangeLog b/mcs/class/System.Data/Test/System.Data.SqlClient/ChangeLog
index 4333feb19fd..d0967cc8a1d 100644
--- a/mcs/class/System.Data/Test/System.Data.SqlClient/ChangeLog
+++ b/mcs/class/System.Data/Test/System.Data.SqlClient/ChangeLog
@@ -1,3 +1,6 @@
+2004-09-02 Umadevi S <sumadevi@novell.com>
+	* SqlDataReaderTest.cs - added file
+
 2004-08-20 Umadevi S <sumadevi@novell.com>
         * Added testcase in SqlDataAdapter.cs for Fillschema
 
diff --git a/mcs/class/System.Data/Test/System.Data.SqlClient/SqlDataReaderTest.cs b/mcs/class/System.Data/Test/System.Data.SqlClient/SqlDataReaderTest.cs
new file mode 100644
index 00000000000..ed5b5e75200
--- /dev/null
+++ b/mcs/class/System.Data/Test/System.Data.SqlClient/SqlDataReaderTest.cs
@@ -0,0 +1,93 @@
+//

+// SqlDataReaderTest.cs - NUnit Test Cases for testing the

+//                          SqlDataReader class

+// 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 NUnit.Framework;

+

+namespace MonoTests.System.Data.SqlClient
+{

+

+  [TestFixture]

+  public class SqlDataReaderTest : MSSqlTestClient {

+          

+          [SetUp]

+          public void GetReady () {

+                OpenConnection ();

+          }

+

+          [TearDown]

+          public void Clean () {

+		CloseConnection ();

+          }
+
+	 [Test]

+	  /**
+	  The below test expects a table table4 with a bigint column.
+	  **/	
+          public void ReadBingIntTest () {
+		try    {
+				string createquery = "select * from table4;";
+				SqlCommand cmd = new SqlCommand();
+				cmd.Connection = conn;
+				cmd.CommandText = createquery;
+				SqlDataReader r = cmd.ExecuteReader();
+				using (r)
+				{
+					if (r.Read())
+					{
+						//long id = r.GetInt64(0);
+						// the above will not work since we are using Tds70 due to which Bigint is mapped to decimal, change this when we use tds8
+						decimal id = r.GetDecimal(0);
+						Assert.AreEqual(123456,id);
+					}
+
+				}
+                        }

+		catch  (Exception e) {
+			Assert.Fail("A#01 Got an exception");
+			//Console.WriteLine(e.StackTrace);
+			
+		}
+                 
+		finally { // try/catch is necessary to gracefully close connections

+                       
+                        CloseConnection ();

+                }

+          }

+
+
+
+	
+	
+    }

+}