>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

You may already have decided but, if the data is fairly simple in structure, I'd got with EF (or nHibernate). If your sending data over the wire datatables are not a good choice so you'd probably need to convert the datatable to an object based structure anyway - may as well let EF do that for you.

EF can be a bit of a pain if the underlying database is in a state of flux - otherwise it's pretty straightforward.....