Saturday, 14 September 2013

Insert in parent child table + Oracle + Entity framework 5 + VS 2012

Insert in parent child table + Oracle + Entity framework 5 + VS 2012

I have been started working on EF 5 on oracle database and as first
assignment I have to insert into parent child tables in oracle database.
But I am facing an issue with inserting record in child table because
oracle doesn't return identity column from parent table like sql server.
I want to use EF with oracle database in same manner as I was using with sql.
I don't want to use trigger to insert into parent child tables
Also I don't want to use generating sequences before inserting into parent
and child tables
We have very high operations on these tables so we can't go with above
options.
Please suggest if there is any other out of box option available with EF 5
in VS 2012 ultimate edition.
Thanks you,

No comments:

Post a Comment