Update/Create Parent enity and Child entities using ExecuteMultiple

• Question

• 

  

  0

  Sign in to vote

  I'm trying to import Accounts(Update them if I already have them)and import upto 4x Contacts(Related Entities) per account:

  I've got my solution working, but wanted to use ExecuteMultiple(I think this would improve performance dramatically) so created a collection of updates and creates.

  foreach (var entity in addUpdateList)
  {
  	if (entity != null && (entity.Id == null || entity.Id == new Guid()))
          {
          	CreateRequest createRequest = new CreateRequest { Target = entity };
          	requestWithResults.Requests.Add(createRequest);
          }
          else
          {
          	UpdateRequest updateRequest = new UpdateRequest { Target = entity };
          	requestWithResults.Requests.Add(updateRequest);
          }
  }

  I used "{ENTITY}.SetRelatedEntity(RELATIONSHIP,ParentENTITY)", but noticed that I got the following errors ""Cannot insert duplicate key."

  after plenty of reading I found an article that mentioned that "Each request is independent of other requests in the same batch, so you could not, for example, execute a CreateRequest followed by an UpdateRequest using the newly created ID within the same batch." I presume I can't create a parent and a child in the same call?

  Any suggestions?

  Tuesday, September 9, 2014 12:00 AM