Hello Fabian,

Could you please inform what type of repository that you use? Is it EditableEntityRepository?

Also, could you please inform the error you received in details?

Thanks!

Yes, I am using the EditableEntityRepository.

I am getting a foreign key contraint violation. Especially if I add two or more childs.

Should I use another repository? Is there a code sample?

Have you tried the following?

this.Item = this.ItemRepository.Create();

// set the ItemId to avoid foreign key constraint violation
Child child = new Child() { ItemId = this.Item.Id };
this.Item.Childs.Add(child);


this.ItemRepository.Insert(this.Item);
this.ChildRepository.Insert(child);

this.ItemRepository.SaveChangesAsync();
this.ChildRepository.SaveChangesAsync();

Hope this helps.

This is working. But you have two change operations and server calls now.

1. This woul increase incoming traffic on the server. Bad if you have to pay for.

2. If you have two relations you would have to keep three repositories. More relations -> more repositories to keep. You would need more memory.

I would expect a more efficent way to get this done. Especially within an enterprise application. The "normal" entitie framework can handle this with just one call.