Is there a way to set the State property of all ValueItems in one shot?

[mike_meirovitz]

Hi,

Is there a way to set the State property of all ValueItems in one shot?

We would like doing it in one shot instead of looping through all value items. The ValueItems belong to an EWS server.

Thank you.

Mike

[JeffBowman · Accepted solution]

Hi Michael,

If we are talking about a single batch call to the SQL database, the best way I can see to do this will be like in the pseudo code below.

myEwsServerDataAdapter.AutoCommit = false;

foreach (var valueItem in myEwsServerDataAdapter.ValueItems)

{

       valueItem.State = TheStateYouWannaSet 
}

myEwsServerDataAdapter.CommitChanges();
myEwsServerDataAdapter.AutoCommit = true;

Best Regards,

-Jeff