I'm looking at the comparisons between SQL queries using ADO and ADO.net(?)

ADO has the connection, command and recordset objects which are really flat in structure and easy to use. It was easy to retrieve any info from a database, especially when you had a SQL join of many table involved.

ADO.NET seems to provide the connection, command, dataAdapter and DataSet objects that are used to do the same thing but in a different fashion. And to me, this seems slow and confusing.

My main questions are:

1) Can you use a SQL join in the DataAdapter object, and set this set of records into a dataset (I guess you would have to name this set of data a tablename.)? Or do you have to use a dataAdapter for each table in the database and drop these tables into one Dataset, and then develop the relationship between them? Confusing.

2) Are there any methods to scroll through the DataSet easily. i.e. EOF, BOF, MoveNext, MovePrevious, MoveLast, MoveFirst.
Right now I'm scrolling through DataSet.Tables("Name").rows(index) ..indexing...but this sucks!

3) Are they developing VB.net to feel more like the C++ and Java dot notation and structures?

I have a lot to learn!

I hope you can answer these questions. I'm an Engineer who uses Visual Basic as a tool..I'm not a Computer Programmer with a degree! I hate learning new crap..but I know I need to!!