You shouldn't be creating a connection on application startup anyways as that's bad practice. You ideally want to create the connection as late as possible and then pass that to the adapter.
It means i should open the connection every time i need it ?
Is using EnlistTransaction recommended ?
Actually my application deals with multiple databases.
when i used EnlistTransaction for another database within the same transaction scope , it gave the MSDTC error.
i enabled it from the control panel.
But is this the right way to do it or i am unnecessarily creating a distributed transaction.
( my requirement is to update multiple tables in a single transaction scope and these tables reside across databases )