如何使用c#监视SQL Server表更改？

using System;
using System.Data.SqlClient;

namespace TableChangeMonitoring
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Your SQL Server connection string";
            string tableName = "Your table name";

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();

                string createTriggerQuery = $"CREATE TRIGGER TableChangeTrigger ON {tableName} AFTER INSERT, UPDATE, DELETE AS BEGIN SELECT 1 END";
                using (SqlCommand command = new SqlCommand(createTriggerQuery, connection))
                {
                    command.ExecuteNonQuery();
                }

                using (SqlCommand command = new SqlCommand($"SELECT * FROM {tableName}", connection))
                {
                    SqlDependency dependency = new SqlDependency(command);
                    dependency.OnChange += Dependency_OnChange;

                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        // Process initial data
                        while (reader.Read())
                        {
                            // Process each row
                        }
                    }
                }

                Console.WriteLine("Press any key to stop monitoring...");
                Console.ReadKey();

                string dropTriggerQuery = $"DROP TRIGGER TableChangeTrigger ON {tableName}";
                using (SqlCommand command = new SqlCommand(dropTriggerQuery, connection))
                {
                    command.ExecuteNonQuery();
                }

                connection.Close();
            }
        }

        private static void Dependency_OnChange(object sender, SqlNotificationEventArgs e)
        {
            // Handle table change notification
        }
    }
}