compare values in list and change if necessary

Question

So guys, I have a sharepoint list with and fields like "webID, url, rating" and a c# list with more or less the same fields. My task is to compare the lists by webID and if the row's "rating" field is different than in my c# list then I would like to update it accordingly. This would happen in a feature's event receiver.

What would be the fastest and best approach to do that?

Answer 1

Use CAML-query to get all the items which webID doesn't match your C# list's value and then update it.

This blog should get you started as it also applies for the client object model.

These two should also be helpfull:

1. Client Object Model Basic Example – CAMLQuery
2. CAML and the Client Object Model