Hi!

I've a form on which I'd like to insert new data into an Oracle table. The table gets it's primary key values from a sequence defined in the Oracle database too. So I want that when the form is shown, the value which will be the primary key value of the new data, to be displayed automatically! What is the best way to query the value?

Thanks in advance!

ISession.Save(object) generates a new Id by getting the next value of the Oracle sequence. So you will have to prepare new objects and Save() them, without flushing the session yet (so you can do a rollback if necessary).

BTW I have bad experiences with meaningful primary keys. If this key has any meaning (which it probably does if you want to show it), I would prefer using an alternate key for it and have your data access get a nextvalue of another sequence. You won't have to Save() your objects then.