.net service and MSSQL, need to trigger process and leave
Posted on 2012-08-31
I have a service which is called by an application that simply needs to add or update a row to a database and then return a success, the service has now ended. Meanwhile, the row that was added/updated needs to trigger on a field, on its own without any connection to the first service. That trigger will call a service to do some other table updates.
The point is that the first service must respond fast and will go away while this 2nd performs it's operations. This entire process must be super fast.
Is this possible? How, if so? and the solution must be fast.