2

I have a stored procedure which return SCOPE_IDENTITY() ->int.

Then, if I import that SP in the EF file (Add Function Import), I see something weird.

Mappings in the .edmx file

alt text

when import that SP:

alt text

Why the column Id is treated as int and in the SP as a decimal ? (I know I can cast scope_identity() as int)

Tony
  • 12,405
  • 36
  • 126
  • 226
  • 3
    see this thread http://stackoverflow.com/questions/2601620/why-does-select-scope-identity-return-a-decimal-instead-of-an-integer – Pavel Belousov Nov 19 '10 at 14:02

0 Answers0