CRM 2011 - Set based update using SDK

• Question

• 

  

  0

  Sign in to vote

  This is a CRM 4 and CRM 2011 question, especially if you use CRM online.  I want to do a set based update of hundreds or possibly thousands of records based on a simple attribute check.  In SQL you can obviously do something like:

  Update dbo.Account set custom_followuprequired = 1 where custom_followupdue = 0

  It seems like if I try to do this with the SDK, I need to do a for loop checking each row individually, updating the value if appropriate, then saving the row.  Or even just a query of the ones to be updated, update the record, then save it, move to the next row, etc.

  Anything more than a few rows and this can get pretty time consuming. 

  Ideas?  Am I missing something?

  Tuesday, October 11, 2011 1:53 PM