>>>Plus, they only are generated for *one* table ... what happens for a DataSet that contains many tables? Won't work (at least from what I've seen ... if there *is* a way to generate a TableAdapter for all tables in the DataSet, I don't know how to do it).
>>
>>You can have many TableAdapters in a dataset, typically one is created for each table.
>
>But is it *auto-generated*??

Not sure I understand your question. Each TableAdapter will create a class in the form of {DataTableName}TableAdapter that contains the generated dal for it's associated DataTable. This dal class will have all the methods required for basic CRUD as well as those created by any additional queries added to the TableAdapter. That's one of the neat features is the ability of the TableAdapter to contain multiple queries.

Each TableAdapter class is auto-generated initially. You can go back and make changes and re-generate the class from scratch or you can choose to make manual changes when required.