[Mono-list] Npgsql myCommand.ExecuteScalar type cast issue

[Christopher Bergström]

int i = 0;

// This works and does prints "1".
Response.Write(myCommand.ExecuteScalar());



// This results in the error below.
i = (int)myCommand.ExecuteScalar();


System.InvalidCastException: Cannot cast from source type to destination type.
in <0x000c3> ASP.login_aspx:CheckUserCredentials (System.String username, System.String password)
in <0x00065> ASP.login_aspx:btnSubmit_Click (System.Object sender, System.EventArgs e)
in (wrapper delegate-invoke) System.MulticastDelegate:invoke_void_object_EventArgs (object,System.EventArgs)
in <0x00066> System.Web.UI.WebControls.Button:OnClick (System.EventArgs e)
in <0x00045> System.Web.UI.WebControls.Button:RaisePostBackEvent (System.String eventArgument)
in <0x0000d> System.Web.UI.WebControls.Button:System.Web.UI.IPostBackEventHandler.RaisePostBackEvent (System.String eventArgument)
in <0x00016> System.Web.UI.Page:RaisePostBackEvent (IPostBackEventHandler sourceControl, System.String eventArgument)
in <0x00031> System.Web.UI.Page:RaisePostBackEvents ()
in <0x001ee> System.Web.UI.Page:InternalProcessRequest ()
in <0x000a4> System.Web.UI.Page:ProcessRequest (System.Web.HttpContext context)


The value should* be able to cast into an int?  I'm converting some stuff off SQL server and the equivalent code works in mono.. The only thing I can think is I'm testing this on my dev server which is using a different version of Mono/Npgsql.  Anyone have any ideas.. I'll play with boxing/unboxing, assuming ExecuteScalar returns an object, to see if it's a Mono or Npqsql issue and if it's in SVN head.

Thanks

C.