Getting the id value generated by an insert statement

Getting the id value generated by an insert statement

Postby andy_clem » Fri 25 Feb 2011 22:42

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
andy_clem
 
Posts: 1
Joined: Fri 25 Feb 2011 22:19

Postby AndreyR » Mon 28 Feb 2011 13:01

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?
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle