Page 1 of 1

Getting the id value generated by an insert statement

Posted: Fri 25 Feb 2011 22:42
by andy_clem
Hi,

Can debate do this?

I am looking for a data provider that enables me to use pl/SQL stored procedures for inserting data into oracle tables.

I then want to be able to use the Id column generated by the stored procedure in visual studio.

The new oracle provider nearly does it, but it is very cumbersome and I just wondered whether devart's product is a bit slicker?

Any experiences from real world solutions appreciated.

I want to be able to reference the Id column generated from an oracle sequence

Posted: Mon 28 Feb 2011 13:01
by AndreyR
Are you using any ORM like Entity Framework?
We have mentioned an EF tip concerning using the returned value set by trigger.
Could you please describe in details the scenario and data access approach you plan to implement?