This seems to be the same bug as
https://bugzilla.xamarin.com/show_bug.cgi?id=26546 which has been fixed
recently in the master branch.
On 26/03/15 21:39, Jon Curry wrote:
My first post…so here goes.
I am attempting to port a large enterprise application to mono, and have
been pleasantly surprised at how well most things work.
I am hitting one snag executing a SqlCommand that includes a
SqlParameter whose data type is SqlDbType.TinyInt (have also tried Int),
and whose value is DBNull.Value.
I just installed the latest monodevelop last Friday (v5.7). Any fix or
workaround would be appreciated!
:::Repro C# code:
private static void SqlTest()
{
using ( var con = new SqlConnection( "Application
Name=MyApp;Data Source=machinename;Database=MGLatest_Mono;User
ID=sa;Pwd=xxx;MultipleActiveResultSets=True" ) )
{
con.Open();
using ( var cmd = con.CreateCommand() )
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "DoTest";
cmd.Parameters.Add( new SqlParameter( "@byte",
System.Data.SqlDbType.TinyInt ) );
cmd.Parameters[ "@byte" ].Direction =
System.Data.ParameterDirection.Output;
// cmd.Parameters[ "@byte" ].Value = (byte)0; // THIS WORKS
cmd.Parameters[ "@byte" ].Value = DBNull.Value; // THIS
FAILS (as does null, or omitting)
cmd.ExecuteNonQuery();
Console.WriteLine( cmd.Parameters[ "@byte" ].Value );
}
}
}
:::Repro Store Proc:
createproc DoTest(@byte tinyint output)
as
set@byte = 238
:::Exception:
Unhandled Exception:
System.Data.SqlClient.SqlException: The incoming tabular data stream
(TDS) remote procedure call (RPC) protocol stream is incorrect.
Parameter 1 ("@byte"): Data type 0x26 has an invalid data length or
metadata length.
_______________________________________________
Mono-devel-list mailing list
Mono-devel-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-devel-list
_______________________________________________
Mono-devel-list mailing list
Mono-devel-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-devel-list
