如何通知客户端WPF应用程序有关远程数据库更改的信息 [英] How to notify a client WPF application about a remote db change

问题描述

亲爱的

我有一个以azure托管的远程sql服务器数据库，该数据库链接到Web管理门户，该门户负责配置一些数据配置后端.
然后，我有一个客户端WPF桌面应用程序，该应用程序将已配置的数据从远程azure数据库同步到本地sql Express数据库，以允许离线使用数据.

I have a remote sql server database hosted in azure linked to a Web admin portal which is charge to configure some data configuration backend.
Then I have a client WPF desktop application which sync configured data from remote azure database to a local sql express db, this in order to allow offLine use of data.

我们的客户要求之一是，当Azure db上的配置部分发生任何更改时，需要尽快将这些更改通知客户端应用程序，以便处理新数据的同步.

One of our customer request is that when any change happen in configuration part on Azure db, client application need to be notify asap about those change in order to process a sync of new data.

如果更合适，我宁愿去通知程序，而不是常规池，但是我不知道该使用什么以及如何实现这种通知.

I would rather prefer to go to a notification process instead of regular pooling if it is more suitable but I have no idea about what to use and how to implement such notification.

感谢您的建议或样品

致谢

推荐答案

你好， 

hello, 

我的第一个反应是考虑服务代理功能，但仅在完全托管的sql azure产品中可用，https://azure.microsoft.com/zh-CN/blog/migrate-your数据库到具有Azure SQL数据库管理实例的完全托管服务/， 我还试图通过EventGrid查找有关Sql Azure事件的信息，也有第三方服务提供与Azure Sql的集成，

the first reflex I had is thinking about service broker feature, but it is only available with the fully managed sql azure offer , https://azure.microsoft.com/en-us/blog/migrate-your-databases-to-a-fully-managed-service-with-azure-sql-database-managed-instance/, also I m trying to find if there is any information about Sql Azure Events through EventGrid, also there is a third party service that offer its integration with Azure Sql, 

https://docs.pivotal.io/partners/azure-sb/installing.html #database

以下是有关使用CF-CLI在Azure Sql数据库上配置服务代理的链接:

how-admin-deploy-the-经纪人

here is a link about using CF-CLI to configure service broker on Azure Sql databases:

how-admin-deploy-the-broker

h 请寻求帮助；

这篇关于如何通知客户端WPF应用程序有关远程数据库更改的信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！