views:

19

answers:

0

Hi guys,

I'm currently using SubSonic 2.2 to code against an Oracle XE DB, which carries certain tables that have a primary key which gets automatically filled by means of a sequence and corresponding trigger.

In SQL Server this isn't a problem, since SubSonic automatically fills in the autoincrement key value into the correct property of my ActiveRecord object, but I'm not sure if this is possible in Oracle; it is not doing it automatically and I haven't found a way to do this aside from manually querying my sequence's CURRVAL and assigning it to the correct property.

Does SubSonic 2.2 currently support this feature or will I have to manually code it as I'm doing it right now?

If this is not available at the moment and I wanted to change my templates and/or certain parts of SubSonic for this to happen, could anyone point me in the right direction as to which files would have to be modified?

Many thanks in advance for your help.