new connection inside onChangeEvent

May 13, 2016 at 2:21 PM
I have a question, in my code when fires event (table dependency onChange) i have to insert new data in the database, but for do that i create a new connection to database. My question is there are another way to do, that wasn't create a new database connection?? because for this work i had to start MSDTC (Microsoft Distributed Transaction Coordinator).
Sorry for my english, i hope someone can help me.
May 16, 2016 at 3:10 AM
I am having the very same issue, Is it possible to use entity framework 6 within an sqltabledependency event?

Please Help