{"action":"created","issue":{"url":"https://api.github.com/repos/christiandelbianco/monitor-table-change-with-sqltabledependency/issues/88","repository_url":"https://api.github.com/repos/christiandelbianco/monitor-table-change-with-sqltabledependency","labels_url":"https://api.github.com/repos/christiandelbianco/monitor-table-change-with-sqltabledependency/issues/88/labels{/name}","comments_url":"https://api.github.com/repos/christiandelbianco/monitor-table-change-with-sqltabledependency/issues/88/comments","events_url":"https://api.github.com/repos/christiandelbianco/monitor-table-change-with-sqltabledependency/issues/88/events","html_url":"https://github.com/christiandelbianco/monitor-table-change-with-sqltabledependency/issues/88","id":345447124,"node_id":"MDU6SXNzdWUzNDU0NDcxMjQ=","number":88,"title":"Why is the SqlDependency object unable to detect the changes in SQL Server table?","user":{"login":"hunaynrestarted","id":36767221,"node_id":"MDQ6VXNlcjM2NzY3MjIx","avatar_url":"https://avatars3.githubusercontent.com/u/36767221?v=4","gravatar_id":"","url":"https://api.github.com/users/hunaynrestarted","html_url":"https://github.com/hunaynrestarted","followers_url":"https://api.github.com/users/hunaynrestarted/followers","following_url":"https://api.github.com/users/hunaynrestarted/following{/other_user}","gists_url":"https://api.github.com/users/hunaynrestarted/gists{/gist_id}","starred_url":"https://api.github.com/users/hunaynrestarted/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hunaynrestarted/subscriptions","organizations_url":"https://api.github.com/users/hunaynrestarted/orgs","repos_url":"https://api.github.com/users/hunaynrestarted/repos","events_url":"https://api.github.com/users/hunaynrestarted/events{/privacy}","received_events_url":"https://api.github.com/users/hunaynrestarted/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":13,"created_at":"2018-07-28T13:06:31Z","updated_at":"2018-07-29T09:54:51Z","closed_at":null,"author_association":"NONE","body":"It's been 3 days that I have been trying to achieve this but couldn't.\r\n\r\nI am using the SqlTableDependency nuget package to get notifications if a particular table's cell gets modified. I have enabled the service broker.\r\n\r\nI have taken every necessary measure. Upon starting the application it creates a trigger, queue, contract, message type automatically on the table and safely disposes upon closing the app but it never returns the results. The database user has Db_Owner role and everything but still not working. Please help me. I am frustrated and tired of this. It's been 3 days.\r\n\r\nI change the values in the edit mode of the table or using an update query.\r\n\r\nI am following this link. It has all the necessary steps and also a demo video. https://github.com/christiandelbianco/monitor-table-change-with-sqltabledependency\r\n\r\nCode:\r\n\r\n```\r\nnamespace SqlDependency\r\n{\r\n    class Users\r\n    {\r\n        public string UserName { get; set; }\r\n        public string Password { get; set; }\r\n    }\r\n\r\n    class Program\r\n    {\r\n        const string ConnectionString = @\"Data Source=(local);Initial Catalog=HimHer; Integrated Security=True\";\r\n\r\n        static void Main(string[] args)\r\n        {\r\n            using(var dep = new SqlTableDependency<Users>(ConnectionString) )\r\n            {\r\n                dep.OnChanged += Dep_OnChanged;\r\n\r\n                dep.Start();\r\n\r\n                Console.WriteLine(\"Press a key to exit\");\r\n                Console.ReadKey();\r\n\r\n                dep.Stop();\r\n            }\r\n\r\n            Console.WriteLine(\"Waiting For Changes ..... \");\r\n            Console.ReadLine();\r\n        }\r\n\r\n        private static void Dep_OnChanged(object sender, RecordChangedEventArgs<Users> e)\r\n        {\r\n            var changedEntity = e.Entity;\r\n\r\n            Console.WriteLine(\"DML operation: \" + e.ChangeType);\r\n            Console.WriteLine(\"ID: \" + changedEntity.UserName);\r\n            Console.WriteLine(\"Name: \" + changedEntity.Password);\r\n        }\r\n    }\r\n\r\n}\r\n```"},"comment":{"url":"https://api.github.com/repos/christiandelbianco/monitor-table-change-with-sqltabledependency/issues/comments/408665107","html_url":"https://github.com/christiandelbianco/monitor-table-change-with-sqltabledependency/issues/88#issuecomment-408665107","issue_url":"https://api.github.com/repos/christiandelbianco/monitor-table-change-with-sqltabledependency/issues/88","id":408665107,"node_id":"MDEyOklzc3VlQ29tbWVudDQwODY2NTEwNw==","user":{"login":"hunaynrestarted","id":36767221,"node_id":"MDQ6VXNlcjM2NzY3MjIx","avatar_url":"https://avatars3.githubusercontent.com/u/36767221?v=4","gravatar_id":"","url":"https://api.github.com/users/hunaynrestarted","html_url":"https://github.com/hunaynrestarted","followers_url":"https://api.github.com/users/hunaynrestarted/followers","following_url":"https://api.github.com/users/hunaynrestarted/following{/other_user}","gists_url":"https://api.github.com/users/hunaynrestarted/gists{/gist_id}","starred_url":"https://api.github.com/users/hunaynrestarted/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hunaynrestarted/subscriptions","organizations_url":"https://api.github.com/users/hunaynrestarted/orgs","repos_url":"https://api.github.com/users/hunaynrestarted/repos","events_url":"https://api.github.com/users/hunaynrestarted/events{/privacy}","received_events_url":"https://api.github.com/users/hunaynrestarted/received_events","type":"User","site_admin":false},"created_at":"2018-07-29T09:54:51Z","updated_at":"2018-07-29T09:54:51Z","author_association":"NONE","body":"check this. \r\n"}}
{"actor":{"display_login":"hunaynrestarted"}}