Hi,

I am using LLBLGenPro 2.5 runtime Version and Adapter model.

My scenario is user will upload a Excel file that contains list of values for related tables in a single row..

Say for example i am having follwoing tables

Person,PersonLocation,PersonSpecialty,PersonDepartment

Relationship is:

A person(Person) can work in more than one location(PersonLocation)

PersonSpecialty can have one or more personlocation id's.

Basically i am getting all the rows from the excel file in a custom collection. I need to use SaveEntityCollection method of adapter while inserting the record against the db.

Suppose in the above case if i am going to insert some new data into person table, whether i can able to get the id(primary key here) of newly inserted row so that i can use the same for inserting new data into the personlocation table.

Please guide me by providing some samples or leads.

Help is very much appreciated.

Regards

Prabhu

How are you creating this custom collection ?

The custom collection contains the list of values for all the related tables. I need to log the status(both success and exception) of each and every row after insertion or updation.

My idea is iterate custom collection and populate all the related tables. If the primary key of an related entity is not there i want to insert else update.

This can easily be done be LLBLGen Pro using a recursive save, as the PK-FK values will be synced automatically for you.

Please check Saving entities recursively in the LLBLGen Pro manual's section: "Using the generated code -> SelfServicing/Adapter -> Using the entity classes"