What is the best way to generate Oracle sequence numbers to work with LLBLGen Pro?

crazylittlemonkeys wrote:

What is the best way to generate Oracle sequence numbers to work with LLBLGen Pro?

Make them available in the schema you want to use them in, then they're loaded into the project automatically. You can then define which field is sequenced with which sequence in the llblgen pro designer, by opening an entity, by double clicking it in project explorer or right clicking it and selecting 'Edit/properties'.

That's great...worked like a charm. Is there a way to automatically propogate the generated sequence number into child classes (tables) that have the id as a foreign key?

crazylittlemonkeys wrote:

That's great...worked like a charm. Is there a way to automatically propogate the generated sequence number into child classes (tables) that have the id as a foreign key?

Yes, if you associate the object to the PK side object. for example you have an Order object with a sequenced OrderID, and you add an OrderRow entity to Order.OrderRows, then, when Order is saved, it will automatically propagate its new OrderID to the OrderRow entities in its collection, or when Order is not new, it will immediately do that when OrderRow is added to Order.OrderRows