diff options
author | Gert Driesen <drieseng@users.sourceforge.net> | 2009-01-17 02:42:44 +0300 |
---|---|---|
committer | Gert Driesen <drieseng@users.sourceforge.net> | 2009-01-17 02:42:44 +0300 |
commit | 42d7ff075414f3240984e59e109dcee8cf2f8d57 (patch) | |
tree | f2a4c76eb1ec3071c292c1eda09be06b5275ed13 /mcs/class/System.Data/Test | |
parent | e456318ec38ff9e97b99f06ba61adf5a610df83c (diff) |
Use existing sp for testing bug326182.
svn path=/trunk/mcs/; revision=123671
Diffstat (limited to 'mcs/class/System.Data/Test')
-rw-r--r-- | mcs/class/System.Data/Test/ProviderTests/System.Data.SqlClient/SqlCommandTest.cs | 38 |
1 files changed, 7 insertions, 31 deletions
diff --git a/mcs/class/System.Data/Test/ProviderTests/System.Data.SqlClient/SqlCommandTest.cs b/mcs/class/System.Data/Test/ProviderTests/System.Data.SqlClient/SqlCommandTest.cs index 644dfd416a0..e4f2c47be03 100644 --- a/mcs/class/System.Data/Test/ProviderTests/System.Data.SqlClient/SqlCommandTest.cs +++ b/mcs/class/System.Data/Test/ProviderTests/System.Data.SqlClient/SqlCommandTest.cs @@ -2557,42 +2557,23 @@ namespace MonoTests.System.Data.SqlClient try { conn = (SqlConnection) ConnectionManager.Singleton.Connection; ConnectionManager.Singleton.OpenConnection (); - string create_proc = "CREATE procedure #sp_326182 ( " + Environment.NewLine + - "@param0 int out," + Environment.NewLine + - "@param1 int out," + Environment.NewLine + - "@param2 int out," + Environment.NewLine + - "@param3 int out" + Environment.NewLine + - ")" + Environment.NewLine + - "as" + Environment.NewLine + - "set @param0 = 100" + Environment.NewLine + - "set @param1 = 101" + Environment.NewLine + - "set @param2 = 102" + Environment.NewLine + - "set @param3 = 103" + Environment.NewLine + - "return 2"; try { SqlParameter param0 = new SqlParameter ("@param0", SqlDbType.Int); + param0.Direction = ParameterDirection.Output; SqlParameter param1 = new SqlParameter ("@param1", SqlDbType.Int); + param1.Direction = ParameterDirection.Output; SqlParameter param2 = new SqlParameter ("@param2", SqlDbType.Int); + param2.Direction = ParameterDirection.Output; SqlParameter param3 = new SqlParameter ("@param3", SqlDbType.Int); + param3.Direction = ParameterDirection.Output; SqlParameter rval = new SqlParameter ("@RETURN_VALUE", SqlDbType.Int); + rval.Direction = ParameterDirection.ReturnValue; - cmd = new SqlCommand (); - cmd.CommandText = create_proc; - cmd.CommandType = CommandType.Text; - cmd.Connection = conn; - cmd.CommandTimeout = 90; - cmd.ExecuteNonQuery (); - - cmd.CommandText = "dbo.[#sp_326182]"; + cmd = conn.CreateCommand (); + cmd.CommandText = "dbo.[sp_326182a]"; cmd.CommandType = CommandType.StoredProcedure; - param0.Direction = ParameterDirection.Output; - param1.Direction = ParameterDirection.Output; - param2.Direction = ParameterDirection.Output; - param3.Direction = ParameterDirection.Output; - rval.Direction = ParameterDirection.ReturnValue; - switch (paramOrder) { case 1: cmd.Parameters.Add (param0); cmd.Parameters.Add (param1); @@ -2624,11 +2605,6 @@ namespace MonoTests.System.Data.SqlClient param2Val = (int) cmd.Parameters ["@param2"].Value; param0Val = (int) cmd.Parameters ["@param0"].Value; } finally { - /* Delete the created stored procedure */ - cmd = conn.CreateCommand (); - cmd.CommandText = "drop procedure #sp_326182"; - cmd.ExecuteNonQuery (); - cmd.Dispose (); cmd = null; } |