Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Why 'insert' trigger three TableChangedEvent? #63

Open
dcuti8 opened this issue Apr 30, 2019 · 0 comments
Open

Why 'insert' trigger three TableChangedEvent? #63

dcuti8 opened this issue Apr 30, 2019 · 0 comments

Comments

@dcuti8
Copy link

dcuti8 commented Apr 30, 2019

I use the example code, but when i insert data in SSMS, the TableChangedEvent trigger three times in this order --- NotificationType.None, NotificationTypes.Update, NotificationTypes.Insert.

I want to monitor update, insert, delete event, when I delete and update data in SSMS it works perfectly. Just the insert trigger three times...

`var listener = new SqlDependencyEx(connectionString, "DatabaseName", "TableName");

listener.TableChanged += (o, e) =>
{
//logic code
};

listener.Start();`

Thanks for any reply!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant