There exists a page on EjbVsAdoDotNet. Perhaps AdoDotNet specifics can be moved here instead.
For introduction to AdoDotNet see http://visualbasic.about.com/library/weekly/aa041203a.htm
A reference to this technology, called .NET Data Access Architecture Guide, can be seen at http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnbda/html/daag.asp
Designing Data Tier Components and Passing Data Through Tiers.
A microsoft perspective is found at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/BOAGag.asp
AdoDotNet reloaded Second time around it is better
A good Article ADO.NET Topic... "4 Techniques to update databases thru datasets when joins are involved" http://dotnetjini.jigneshdesai.com/dotnet-whidbey/ShowArticle.aspx?ID=2
See also ActivexDataObject