IsNemoEqualTrue / monitor-table-change-with-sqltabledependency

Get SQL Server notification on record table change
MIT License
655 stars 177 forks source link

Detecting only Insert and update but not the Delete #245

Open garciamsu opened 1 year ago

garciamsu commented 1 year ago

I have several tables to which I am detecting shots, and I am presented with the following problem.

Table 1 where the number of fields declared in the c# class fully matches the design of the SQL server, and the triggers (INSERT, UPDATE and DELETE) work OK but...

I have another table 2, where the number of fields declared in the C# class is less than the total number of fields in the SQL server because I don't need to detect all changes and only INSERT and UPDATE work but DELETE doesn't work.

What can I do to solve this situation????

Thank you