diff options
author | Sureshkumar T <suresh@mono-cvs.ximian.com> | 2005-10-08 13:57:37 +0400 |
---|---|---|
committer | Sureshkumar T <suresh@mono-cvs.ximian.com> | 2005-10-08 13:57:37 +0400 |
commit | 88683eb2b226c25b3c7b059eb66356cb470b798e (patch) | |
tree | b25ab4df5c0b8ebe77a7d793b305c36342ab6e9e /mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcParameterTest.cs | |
parent | 3f3bceed39d7b5243b2bf2e281ecd11d949134f9 (diff) |
In System.Data.Odbc:
2005-10-08 Sureshkumar T <tsureshkumar@novell.com>
* OdbcParameterTest.cs (OdbcTypeTest): Disconnected Tests for
OdbcParameter class.
In ProviderTests/sql:
2005-10-08 Sureshkumar T <tsureshkumar@novell.com>
* mysql.sql: impact from sqlserver.sql.
In ProviderTests/System.Data.Odbc:
2005-10-08 Sureshkumar T <tsureshkumar@novell.com>
* OdbcParameterTest.cs: Corrections.
svn path=/trunk/mcs/; revision=51461
Diffstat (limited to 'mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcParameterTest.cs')
-rw-r--r-- | mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcParameterTest.cs | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcParameterTest.cs b/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcParameterTest.cs index 84e498f8898..c2401bf06e9 100644 --- a/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcParameterTest.cs +++ b/mcs/class/System.Data/Test/ProviderTests/System.Data.Odbc/OdbcParameterTest.cs @@ -93,7 +93,7 @@ namespace MonoTests.System.Data OdbcCommand cmd = (OdbcCommand) conn.CreateCommand (); cmd.CommandText = query; - OdbcParameter param = cmd.Parameters.Add ("type_smallint", OdbcType.BigInt); + OdbcParameter param = cmd.Parameters.Add ("type_smallint", OdbcType.SmallInt); param.Value = 32767; OdbcDataReader reader = cmd.ExecuteReader (); Assert.IsTrue (reader.Read (), "#1 no data to test"); @@ -113,7 +113,7 @@ namespace MonoTests.System.Data OdbcCommand cmd = (OdbcCommand) conn.CreateCommand (); cmd.CommandText = query; - OdbcParameter param = cmd.Parameters.Add ("type_tinyint", OdbcType.BigInt); + OdbcParameter param = cmd.Parameters.Add ("type_tinyint", OdbcType.TinyInt); param.Value = 255; OdbcDataReader reader = cmd.ExecuteReader (); Assert.IsTrue (reader.Read (), "#1 no data to test"); @@ -242,6 +242,8 @@ namespace MonoTests.System.Data int count = (int) cmd.ExecuteScalar (); Assert.AreEqual (1, count, "#1 value not matching"); } finally { + ConnectionManager.Singleton.CloseConnection (); + ConnectionManager.Singleton.OpenConnection (); DBHelper.ExecuteNonQuery (conn, "delete from binary_family where id = 6000"); ConnectionManager.Singleton.CloseConnection (); } @@ -283,8 +285,11 @@ namespace MonoTests.System.Data cmd.CommandText = "select count (*) from string_family where id = 6000"; Assert.AreEqual (1,(int) cmd.ExecuteScalar (), "#1 value not matching"); } finally { + ConnectionManager.Singleton.CloseConnection (); + ConnectionManager.Singleton.OpenConnection (); DBHelper.ExecuteNonQuery (conn, "delete from string_family where id = 6000"); ConnectionManager.Singleton.CloseConnection (); + } } @@ -304,6 +309,8 @@ namespace MonoTests.System.Data cmd.CommandText = "select count (*) from string_family where id = 6000"; Assert.AreEqual (1,(int) cmd.ExecuteScalar (), "#1 value not matching"); } finally { + ConnectionManager.Singleton.CloseConnection (); + ConnectionManager.Singleton.OpenConnection (); DBHelper.ExecuteNonQuery (conn, "delete from string_family where id = 6000"); ConnectionManager.Singleton.CloseConnection (); } |