SqlCeParameter and ParameterDirection.Output

[Rüdiger Kardel]

Hi,

the second line of the source:

SqlCeParameter orderIDParameter = new SqlCeParameter("@OrderID",
SqlDbType.Int, 4);
orderIDParameter.Direction = ParameterDirection.Output;

throws the exception:
"Invalid direction 'Output' for '@OrderID' parameter."

What am I doing wrong?
As far as I understood, "ParameterDirection.Output" should be supported by
CF

Env.:
VS2008
CF 2.0
WM 5.0
Microsoft SQL Server Compact Edition\v3.5\

regards
Ruediger

 

[Ginny Caughey MVP]

Hi Ruediger,

It appears from this reference that Direction always returns
ParameterDirection.Input on the Compact Framework:
http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlceparameter.direction.aspx

 

[Rüdiger Kardel]

Hi Ginny,

thanks for the link.
what I had found was:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlparameter.direction(VS.80).aspx

Didn't recognize that the "CE" was missing.
Anyway: for my purpose a workaround was easy. I just wanted to catch the new
@@identity.

CU in November in Hamburg?

Greetings
Ruediger

 

[Ginny Caughey MVP]

Hi Ruediger,

I'm glad you got it working.

Unfortunately I won't be in Hamburg this year due to a scheduling conflict.
Dieter can tell you all about it, but I hope to make it back to Germany the
following year.

 

[kappak]

Anyway: for my purpose a workaround was easy. I just wanted to catch the new @@identity.

Hi, can you please share this easy workaround ? I googled for a week, could not find it