We can open a connection and pass it to multiple dataAdapters before closing
the connection. How is this handled with TableAdapters when we call queries
from multiple tableAdapters?

Let's say I want to populate specific queries on a number of datatables. 
I've configured the tableAdapters for each table with my parameterized
queries.  Now, I want to use a single open/close on a connection.  With
multiple dataAdapters, I open the connection first, use it while creating the
DAs and then close it after the last.  How would this procedure translate to
a TableAdapter since no connection object is exposed?

TableAdapters and true N-Tier
Error accessing MS Access database with Linked Tables on fileshare
Create my own db connection wizard
A problem with the datagrid
two disimilar tables - Report