I have a Windows application in which a major design change is to be implemented. Part of this redesign requires establishing a connection to the DB. This connection periodically gets closed and then reopened. In a specific section of the application, I have to write partial data to the database at the beginning of a certain process. When the process is finished, I write more data to the DB. All the data written in this process makes up a single transaction.
My question is this. Can I establish a single instance of a SQL Transaction and apply it to this process even though the DB Connection has been opened and closed multiple times?