Ok I'm quite fluent with VB6's ADO but now I have to learn Ado.net and I have some question if anyone can help.

I see they added a new layer between the data/db, a Adapter, I'm assuming other than being a data pipe between the dataset and db, it's not really used directly?

Also I'm confused now, I am used to recordsets where if I need a record, I simply query it from the database and store the data in a recordset so I can work with it. The dataset seems to have the same function but instead you can query multiple records, or a whole table and store it into memory? Now when you change a value in the dataset, does it automatically change in the DB? Can you use a Dataset like a normal memory space and access/write to it as you can a variable or what?

What about multiple Tables, I have dozens of tables, do I need to load each table in a seperate dataset or can I just load the whole database into the dataset and access the dataset as I would normally the database in old ado?

any insightfull feedback would be greatfull..