Scenario:

“I love early bound code because of compile time checking, LINQ query enablement, etc.  I want to batch update a bunch of records, but OrganizationServiceContext.SaveChanges() executes under the hood as one web service call per entity.  How do I batch update?  Also, how do I make sure that only the fields I change are updated?”

The answer is that you basically have to combine your crmsvcutil.exe generated code with ExecuteMultipleResults.  Here’s an example:

var conn = CrmConnection.Parse("USE A VALID connection string using appropriate format documented at https://msdn.microsoft.com/en-us/library/jj602970.aspx");

var ctx = new marcsctest1Context(new OrganizationService(conn));


// NOTE: The query below uses LINQ projection.  The CRM LINQ provider will translate this to a query that only returns ID & Name

var query = 

    from a in ctx.AccountSet

    select new Account

    {

        Id = a.Id,

        Name = a.Name

    };


var executeMultipleRequest = new ExecuteMultipleRequest()

{

    Settings = new ExecuteMultipleSettings(){

        ContinueOnError = false,

        ReturnResponses = true

    },

    Requests = new OrganizationRequestCollection()

};


foreach (var account in query)

{

    account.Name += " - Updated";

    //UpdateObject is required to set the EntityState to Changed because it is readonly through crmsvcutil generated entities

    ctx.UpdateObject(account); 


    executeMultipleRequest.Requests.Add(new UpdateRequest()

    {

        Target = account

    });

}


//Don't forget to check response.IsFaulted and handle appropriately

var response = ctx.Execute(executeMultipleRequest) as ExecuteMultipleResponse;
@devkeydet
Share this:
Twitter
Facebook
Like this:
Like Loading...


	
Related