Is there any way with LLBLGen Pro generated code (SS,2.5) to copy records and the child path to a new set of records?
Currently I do this in a stored procedure using complex joins. Take a structure like this as follows:
tblParent (uses identity primary key column)
-->tblChildren (uses identity primary key column)
-->tblChildrensChildren (uses identity primary key column)
The only real complex part of this scenario is that when you copy the record in tblParent to a new record you must copy all of the children but keep the foreign key of the new parent and disregard the old foreign key, and then you must do the same thing for all of the ChildrensChildren. It's involved me having to write stored procedures with fairly complex joins and FETCH statements. New primary keys are generated for new (copied) records so after a record is inserted, the new primary key must be retrieved and is used as te foreign key in the child table.
I'm not asking if I can use the stored procedure in LLBGen Pro because I know I can, I am wondering if I could disregard the stored procedure and do this failr simple with LLBLGen Pro? Is there something in the object model I am missing that could simplify this or are we would I have to do a similar thing with LLBLGen Pro that I am with the stored procedures but just with using .NET code (Loops, entity loads, updates, etc).