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!
How to insert value in Sequence column without using Trigger
-
- Posts: 1
- Joined: Mon 22 Nov 2010 12:03
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.
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.