Hello

can any one help me with this. when I insert a new row in the table, how do I get the primary key id from that newly inserted row ?

in MSSQL store procedure, there is a funciton like @@scope_identity() which return the id back to SqlCommand.

I wish the documentation is more helpful than this.

Thank you

You can always save the new ID in a hidden form field and then use the Load feature to load a just saved id. (At least, that's how I do it -- I'm sure there is a better way, but I do not know of it).

This is if your customer wants to search by Social. If you want the program to retreive the clientID from a just saved client, you can save the client (session.Save(client)), and Flush it for good measure (I'd love to know if I don't need to flush it at this point), and then simply save the clientid to a textbox.



I use Hibernate for a WinForms application, and unfortunately, most of the examples I see are for ASP.NET 2.0. I know there isn't much difference, except I don't have to worry about state.

Thanks for your help.