How to insert value in Sequence column without using Trigger

How to insert value in Sequence column without using Trigger

Postby nidhi.bhargava » Mon 22 Nov 2010 12:13

To insert value in Sequence column everywhere I have found only one solution that create trigger and set StoreGeneratedPattern="Identity" attribute.

Is there any other way to insert value in Sequence column without using Trigger because due to some restrictions we connot create Trigger for insert in Sequence column.

Thanks in advance!
nidhi.bhargava
 
Posts: 1
Joined: Mon 22 Nov 2010 12:03

Postby AndreyR » Mon 22 Nov 2010 17:56

I have described a solution for a similar problem here at our forum
In case you are restricted to create procedures in DB, there is a CommandText option in Entity Developer.
CommandText is a SP analogue, but it's stored in SSDL, not in DB.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle