IsNemoEqualTrue/monitor-table-change-with-sqltabledependency

Allow user to pass in Guid to create the trigger with?

Closed this issue · 3 comments

ENHANCEMENT REQUEST - see commit below for my suggestion

GSUFan513@24bfa3e

Currently, we need a way to poll our database and check for a trigger on that table, however if there are multiple triggers on the table, we cannot be positive that one of the ones on there is the one we are looking for.

This commit allows me to pass in the triggers guid to create. This way when we poll sql for the triggers on the table, we are positive the one we started with is still there and functioning. This should have no effect on any users.

Alternatively, you could provide the Guid you are using in a public property if that's easier, but I would REALLY appreciate seeing this code in there as soon as possible.

For the record, this is proving to be a big issue in our use of this code, and without this, I'm afraid we will have to publish our own nuget package to allow this. I think it's an easy and safe change, but if this is something that won't happen anytime soon, I understand.

Hi, with GetBaseObjectsNamingConvention() you can have the naming convention used to create all DB objects. Is not enough?

Ah, I missed this method. I think that is fine for our usage.

Thanks.