I am trying to use ORM.NET and got everything working in a project of mine with 1 small exception. I am inserting data into a table by creating a new object, but what I want to be able to do after the insert is get the ID of the record that was just inserted. does anyone know how I might be able to do that without having to make an additional call to the database? When I was using stored procedures I would return @@Identity for the return code and that would give me the ID of the inserted record.
Thanks.
Chaitanya
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am trying to use ORM.NET and got everything working in a project of mine with 1 small exception. I am inserting data into a table by creating a new object, but what I want to be able to do after the insert is get the ID of the record that was just inserted. does anyone know how I might be able to do that without having to make an additional call to the database? When I was using stored procedures I would return @@Identity for the return code and that would give me the ID of the inserted record.
Thanks.
Chaitanya