使用WCF的服务器客户端两个Sql Express [英] Server Client Two Sql Express with WCF
问题描述
我在使用的一种层模型中有一个客户端应用程序:
客户端应用程序<->服务器上的WCF服务<-具有功能的业务层<-具有实体框架的数据库层
该应用程序还应该可以脱机使用.
我该怎么办?
该应用程序还具有一个数据存储区，其中包含客户文件，产品文件...
我想要一个通过服务与主数据库同步的本地SQL Express数据库.
我认为我需要Microsoft Sync Framework解决方案.
SyncOrchestrator是否可以与服务代理结合使用?
这样，当对主数据库的更改触发事件时，就会启动同步.
与客户端数据库相同.
服务代理如何使用WCF服务?
如何通过WCF服务启动同步?
如何监视服务代理的整个数据库?
如何仅创建服务器的序列ID(客户ID，产品ID)
I have a client application in one of the layers model I use:
Client Application <-> WCF service on the server <- Business Layer with functions <- Database Layer with entity framework
The application should also be available offline.
How could I do that?
The application also has a data store with customer files, product files ...
I would like a local SQL Express database which is synchronized by a service with the main database.
I think I need a solution with the Microsoft Sync Framework.
Is there a way the SyncOrchestrator with the service broker to combine.
So that when a change to the main database triggers an event, which starts the synchronization.
And the same at the client database.
How does the service broker on the WCF service?
How to start a Synchronizing via the WCF service?
How do I monitor the service broker an entire database?
How do I create only the server''s serial ID (CustomerID, ProductID)
Is there another solution to the problem?
推荐答案
您可以实现此功能，需要进行以下设置:
1-在客户端，您需要一个紧凑的数据库.
http://msdn.microsoft.com/en-us/library/bb726043.aspx [ ^ ]
我希望您可以使用此信息构建所需的解决方案.一切顺利.
You can implement this, you need to setup these:
1- At client side you need a compact db.
http://blogs.msdn.com/b/stevelasker/archive/2007/03/31/creating-your-sql-server-compact-edition-database-and-schema-in-code.aspx[^]
2- At server side a sync service which can keep the compact db updated with the database changes.
http://msdn.microsoft.com/en-us/library/bb726043.aspx[^]
I hope you can build the solution that you are looking for with this info. All the best.
这篇关于使用WCF的服务器客户端两个Sql Express的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
