How to insert value in Sequence column without using Trigger

[nidhi.bhargava]

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!

[AndreyR]

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.