I am trying the follwoing

Dim prodMap As New MacPubvenprodmapEntity() With {.PubvenprodId = Guid.NewGuid(), .PubvenId = selectedMap.PubvenId, .ProdId = selectedAddProduct.ProdId, .ProdName = selectedAddProduct.ProdName } selectedMap.MacPubvenprodmaps().Add(prodMap) selectedMap.Save()

But the changes are nor being saved in the DB. There is a FK relationship between selectedMap and MacPubvenprodmapEntity.

The following works

Dim prodMap As New MacPubvenprodmapEntity() With {.PubvenprodId = Guid.NewGuid(), .PubvenId = selectedMap.PubvenId, .ProdId = selectedAddProduct.ProdId, .ProdName = selectedAddProduct.ProdName } prodMap.Save()

What is the difference between both codes? What is selectedMap.MacPubvenprodmaps() ? What LLBLGen version are you using?

The first set of code...I am trying to add items to the collection of the selectedMap and then try to save selectedMap and have it save the items in the collection...similar situation to an Order and OrderItems.....I am adding items to the order and then when I save the order entity it automatically saves the items.

daelmo wrote:

What is the difference between both codes? What is selectedMap.MacPubvenprodmaps() ? What LLBLGen version are you using?

Got it to work by

prodMap.Save(True)

"When true, it will save all dirty objects referenced (directly or indirectly) by this entity also."

Oh, yeah, recursively save Good you got it working.