Dynamics CRM & .NET (C#) Set field value for all rows

Question

With the help of the OrganizationService, I want to give the value of a particular column the same value for each row in a table (with a condition). How do I do that all at once?

This is how I should do it in SQL:

UPDATE [XXX]
SET Status = "Draft"
WHERE parentId = 1

Answer 1

There’s no equivalent CRM SDK code to do it like your sample SQL. Because each CRM record update has to go through either service.Update() method or UpdateRequest.

Refer this SO thread for execution of bulk requests using ExecuteMultipleRequest