IsNemoEqualTrue / monitor-table-change-with-sqltabledependency

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

Is there a limit to the number of fields that can be declared in the C# class for trigger detecting? #246

Open garciamsu opened 1 year ago

garciamsu commented 1 year ago

Hello

Is there a limit to the number of fields that can be declared in the C# class for trigger detecting?

Because when I have a table 1 in SQL Server with 14 fields, and when I declare all the fields in the C# class it works from the OK trigger (INSERT, UPDATE and DELETE) but...

Because when I have a table 2 in SQL Server with 145 fields, and when I declare all the fields in the C# class, no trigger works (INSERT, UPDATE and DELETE)

What I can do???