Until quite recently, my TD.NET usage had been quite conservative, I'd used it to run tests but had ignored all the surrounding features (why confuse things?). The past few days I've gotten into using some of the more funky features TD.NET bundles...
Crikey - they've done it again! Red Gate have *yet again* released another stunningly simple product jam packed full of features! http://www.red-gate.com/messageboard/viewtopic.php?t=3592 Download it and have a play!
Mike Taulty found a really interesting piece on The future of ADO.NET buried on MSDN.
Spotted this post on ASP.NET and ADO.NET best practices , it's not an exhaustive list, but there is some good advice there.