[C#/.NET]Is it possible to subscribe to data changes in a table in SQL Server?

Question

I do not want to poll for changes in a table. Is there any mechanism to subscribe to data changes in SQL Server using C#?

Answer 1

Check the mecanisms that are based on SqlDependency and SqlNotificationRequest:

• https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/query-notifications-in-sql-server

See also:

• https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/track-data-changes-sql-server