Allow Stored Procedure for Primary Key
We would like to use a stored procedure to generate our primary keys in an OrmLite object. The default field almost can be used for this purpose. But I have to use the special version of Insert which only sets certain fields. However, there is no version of that method which also returns the new id generated for the row. Perhaps you could add an AutoIncrement attribute that allows you to specify a stored procedure. Or at least adda version of Insert that only sets certain fields, but still returns the new id.
Jason Pepper
shared this idea
-
Johann Klemmack
commented
Do you mean to *generate* the primary key via stored proc, or truly have it as a calculated column? If generate, you could always decorate the property in the POCO with "[PrimaryKey]" ,then use an insert trigger to generate the value.