ADO.NET - are tableadapters any use ?

I'm getting to grips with ADO.NET (actually ADO.NET 2.0), and I'm left wondering, just how much use are TableAdapters ?
- I've gone from not much use to useful back to not much use

Also System.Transactions and TransactionScope
- this seems a really nice way to handle transactions, simply wrap all the bits of work in ...
Using ... TransactionScope
{
// do work here
}

Alas we're an Oracle site, and as of now (28/4/2006), it seems that like SQL Server 2000, if you use this approach, the transaction gets promoted up to DTC :-(
- bummer
- there are various ways round this, thanks to Partial Classes, one example is mentioned in the blog of Jackie Goldstein and is shown in the Teacher starter kit for the Express versions of Visual Studio
http://msdn.microsoft.com/vstudio/express/sql/starterkit/default.aspx#teacher

What I really want is a tool that can take the XSD, including either the ms attributes designed for the MsDatasetGenerator or some other equivalent ones, and spit out a nice data access layer for me
- got a response from Dan ?? (guy who co-wrote XsdObjectGen) and they are planning a NET 2.0 version of it, with lots of nice updates, like partial classes, nillables, generics ...