Getting a ReturnValue from cmd.Parameters in c#?

I have just finished converted a vb.net app to c# and one of the lines is to get @ReturnValue from the parameter.

I ended up having to CAST a lot of things..

Is there not a easier way

here is what i have

int rc = ((System.Data.SqlTypes.SqlInt32)(((System.Data.SqlClient.SqlParameter)(cmd.Parameters["@ReturnValue"])).SqlValue)).Value;

In vb.net it was as simple as doing this

Dim rc As Integer = Convert.ToInt32(cmd.Parameters("@ReturnValue").Value)

Alot easier :-)

But the problem with C# is the property Value isn't available unless I Cast to SqlParameter and i also need to cast to Sqltypes.SqlInt32 - i can't just do a standard Convert.开发者_如何学CToInt32

---

This isn't a C# versus VB.NET thing - it's about the types you're using to declare your variables. If cmd is an IDbCommand, you're in for a lot of casting.

The IDbCommand.Parameters property returns an IDataParametersCollection, which contains a collection of Object instances. Since Object doesn't have a property called Value, you need to cast each instance to SqlParameter before accessing Value.

SqlCommand.Parameters, by contrast is a SqlParameterCollection, which contains a collection of SqlParameter instances. If you declare your cmd variable as a SqlCommand, you can access its parameters' values in the straightforward way to which you're accustomed. (At the cost of being tightly coupled to the implementations in the SqlClient namespace.)

---

It's just as easy to do it in C#:

int rc = (int) cmd.Parameters("@ReturnValue").Value;