I'm back at accessing some sql data in c#.

Whats flavour of the month on the best and easiest way to do this. I'm not creating a framework and am more than happy to hard code some things in.

I want to read all the rows in a table and use it to update some data via a web service and update rows back on the table depending on the web service response,

Previously I've used datareaders etc.

Any thoughts