Insert Procedure in oracle which return the new unique ID

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
aloneldi
Posts: 2
Joined: Thu 23 Apr 2009 11:34

Insert Procedure in oracle which return the new unique ID

Post by aloneldi » Thu 23 Apr 2009 11:42

I created 3 procedures :
Insert,Update and Delete.

The update and Delete are getting only input parameters.

The insert is returning the new unique id of the row.
How do I map the out parameter for the insert procedure ?

When saving the new Model I'm getting the error :

**********************************************
Error 1 Error 2047: A mapping function binding specifies a function Model.Store.INSERTCONTACT
with an unsupported parameter: O_CONTACT_ID. Output parameters may only be
mapped through the RowsAffectedParameter property.
Use result bindings to return values from a function invocation.
C:\C#\EntityFrameWork\ConsoleApplication1\ConsoleApplication1\Model1.edmx
209 17 ConsoleApplication1

*****************************************************

Thanks

Alon

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 23 Apr 2009 13:55

This problem was already discussed at our forum here:
http://devart.com/forums/viewtopic.php?p=44894
We have sent you a workaround.

Post Reply