>>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.....

LOL :-(

the current client is so locked down that db access is now not "necessary" because the dba says no to creating a table. I seem to be in a cycle of increasing pay "good" and increasingly difficult clients "bad" .