Passing an object array as ref to function.

[craigkenisston]

Hi,

I'm trying to create a generic function to call stored procedures in a
SQL Server database.
I'm passing the params, values and the direction of the params in
arrays.
The function is working, and I get the output parameters values back in
my the array I sent, however, I'd like to have the values in my
original variables, please see below :
int ID = 0;
string[] Params = {"@USER_USERID", "@USER_ID"};
object[] Directions = {ParameterDirection.Input,
ParameterDirection.Output };
object[] Values = {UserID, ID};
DbSQLServer.ExecuteScalarStored("clsd_GetUserID",
Params, Directions, ref Values);
Console.WriteLine(ID);

at the end of this run the value of ID is zero. But the value of
"Values[1]" (the second) has the returning value of my function.

What I want here, is to be able to fill the original variables
directly, I mean, to put the values in "UserID" and "ID".
I could to this easly with pointers, but without them I feel like hands
tied.

Is this possible ? Or am I just looking for something that can't be
done.

Any recommendation is welcome.

[Lasse Vågsæther Karlsen]

cr************@hotmail.com wrote:

Hi,

I'm trying to create a generic function to call stored procedures in a
SQL Server database.
I'm passing the params, values and the direction of the params in
arrays.
The function is working, and I get the output parameters values back in
my the array I sent, however, I'd like to have the values in my
original variables, please see below :

<snip>

You're looking for something that can't be done, unless you resort to
unsafe code, where you can use pointers. I wouldn't recommend it though.

--
Lasse Vågsæther Karlsen
http://www.vkarlsen.no/
mailto:la***@vkarlsen.no
PGP KeyID: 0x0270466B