Dmitriy Dyatchenko
Dmitriy Dyatchenko
Hello, Unfortunately, it isn’t available in current implementation. However, it is possible to implement using UPDATE() function. https://www.mssqltips.com/sqlservertip/6076/how-to-find-updated-column-in-sql-server-trigger/ Thanks, Dmitrii On Sat, 6 Jun 2020 at 07:07, arkgroup wrote: >...
Hm. What part of the sample code is unclear? There are 3 steps: 1. You create and instance of SqlDependencyEx 2. You subscribe on event notifications (TableChanged event) 3. You...
There is a XML property: public XElement Data You can use that to see what actual data was inserted/deleted/updated (all columns with data are included as text). The sample project...
Hello, You can check how it works in unit tests [here](https://github.com/dyatchenko/ServiceBrokerListener/blob/master/ServiceBrokerListener/ServiceBrokerListener.UnitTests/SqlDependencyExTest.cs). Please let me know if you have any other questions. Thanks, Dmitrii
Hello, Could you please share what SQL version are you running it on? Thanks, Dmitrii
Hi, Why don’t you just filter out events you don’t need right in the event handler? So notifications will happen, but the rest of the application will get only those...
Hello, Thanks for reporting this issue. Looks like when there are too many simultaneous notifications some of them fail to dispose. Let me run some tests and see what I...
Hi @MitkoDMTR, Thanks for the remark. It is a good idea and will be implemented as soon as possible. Thanks, Dmitrii