TableAdapter connections when filling multiple tables

G

Guest

When filling multiple tables with DataAdapters, I explicity open the
connection object that is passed to the DataAdapter before and close it after
the tables are filled.

Now, in 2.0, I'm filling multiple tables with TableAdapters and making use
of the extended query capacity. It looks like the TableAdapter uses the
connection object of the typed dataset and I can't seem to find it to
open/close it explicitly. Is this something that will degrade performance as
each TableAdapter seems to open and close the connection individually?

Thanks for helping me understand TableAdapters better
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filling tableadapaters in master/child dataset 8
Multiple providers with typed tableadapter 3
Efficient Filling Multiple DataTables 2
TableAdapter vs DataAdapter 4
Avoiding escalation to MSDTC with multiple TableAdapter inserts 5
Data Access Layer using TableAdapter & Performance / Packaging 1
Working with multiple typed datasets under same transaction 2
DataAdapter newbie question 2

Top