I need to get notification when the user insert or update on database on azure server ... this could happen be Enable_Broker in IIS server. Unfortunately azure does not support Service Broker... Is there Alternative, What I can use to get notification on update or insert database..
相关问题
- Generic Generics in Managed C++
- running headless chrome in an microsoft azure web
- Docker task in Azure devops won't accept "$(pw
- How to Debug/Register a Permanent WMI Event Which
- 'System.Threading.ThreadAbortException' in
Microsoft has just released "Managed Instance" in preview which supports Service Broker with some limitations (ex: cross-instance service broker is not supported).
Overview of Managed Instance
Service Broker Differences
That is one of the limitations of SQL Azure (i suppose you mean SQL Azure. You may vote for the feature on the official UserVoice. Alternative should be use of full-fledged SQL Server on the Azure VM or use of some kind of messaging queue like Azure Storage Queue (when updating/creating/etc, send the message to the queue as a notification, and a receiver on the other end).
From comments section:
For use of Storage Queues, there is an official tutorial that works very well. Except configuration, you need "Insert a message into a queue" and "De-queue the next message" sections. So, your solution may look like: Your app is doing the change in the database => once it completes, app inserts the message into the queue => once it is done, that message should be de-queued on the other side with other application (which is the side that should be notified about changes).