#1 mORMot 1 » How to obtain the auto generated primary key value after an insert » 2012-01-25 20:11:59

gururamnath
Replies: 6

Hi,
I'm using the TSQLDBStatement's Execute function to do a insert of a record. I'm not sure how I can get the auto generated primary key value of the newly inserted record. Can anyone let me know how to get the value ?

Thanks,
Guru Kathiresan

#2 mORMot 1 » A simple ORM based on mORMot DB Libraries » 2011-11-28 23:31:37

gururamnath
Replies: 1

Hi,
I'm in the process of creating a very simple ORM based on your DB library. It uses new RTTI and is similar to that of the .NET MicroORM - PetaPoco (http://www.toptensoftware.com/petapoco/ ). I'm wondering if you would like to have it added as part of mORMot framework itself ? Here are couple of things I have implemented and I think will be useful :

1) Uses regular Delphi TObject class as entity class
2) Uses RTTI and attributes for finding column information on the fly
3) Uses RTTI Cache to improve column information lookup
4) Ability to use SQL in the ORM
5) Uses .NET's T4 template to generate the Delphi classes for each Tables instead of hard coding each one them.

I just looked at the TMS Software announcement and it almost resembles that of the one I'm creating.

-regards,
Guru Kathiresan

Board footer

Powered by FluxBB