type conversion issue.

[Ashish]

its on .net 2.0

I am calling a stored procedure which returns value SCOPE_INDENTITY() ,
when i try to convert the result from object to int, it throws a type
conversion error...

after some hit and trials i figured out that the returned type is
actually decimal ..,
hence

int i = (int) DataStore.ExecuteScalar(.....) , throws an error

while

decimal d = (decimal) DataStore.ExecuteScalar(.....) , works fine ....


is this consistent, is there a ADO.Net conversion map somewhere for SQL
Server ?


regards
-ashish

 

[Nicholas Paldino [.NET/C# MVP]]

Ashish,

I don't know of where there is a map, but what is the type of your
identity field in SQL?

 

[Ashish]

the identity field is of type int, another point is that iam using Data
Application Block to access the and they are on 1.1, and my application
is on 2.0, can that cause a problem ?

regards

 

[Ashish]

Another point is that when i return

SELECT SCOPE_INDENTITY()

the type returned is System.Decimal

and when i return

SELECT uid FROM Addresses


Then the return value is System.Int32....

looks like sql_variant is being converted to decimal somehow ...

can someone confirm this ?


regards