查找表 Ria 服务
我的应用程序有一个主数据库，其中包含大约 50 个表，这些表用作查找表，并将提供数据来填充组合框和任何其他控件以及一些应用程序设置表。因此，我正在考虑创建这些主表上下文并加载实体，并在用户登录时将其添加到应用程序生命周期上下文对象中，以便我可以在需要时在整个应用程序中访问它们。然而，我也在考虑一种不同的方法，我下载所有表的数据集并将其保存到隔离存储中，并在需要加载组合框时从该数据集中读取表。加载所有表的数据集大小约为 1.2MB。我不知道我应该遵循哪一种，以及这些方法与彼此相比有何缺点，也不知道是否有一种优雅的方法来处理这种情况。有人可以建议我吗？
谢谢， 阿杰。
My application has a master database which has around 50 tables which are used as lookup tables and will provide data to fill the comboboxes and any other controls and also some application settings tables. So I was thinking of creating these master tables context and load the entities and add it to the application life time context object upon user login so that I can access them throughout the application when ever I need. However I am also thinking of a different approach where I download the dataseset of all the tables and save it to the isolated storage and read the tables from that dataset when ever I need to load the combobox. The dataset with all the tables loaded is around the size 1.2MB. I do not know which one should I follow and what will be the shortcomings of these approaches when compared to each other and also is there an elegant way of handling such a case. Can anyone please suggest me ?
Thanks,
Ajay.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
使用任何解决方案时，您面临的第一个问题是当这 50 个表中的任何一个发生更改时同步。您如何知道更改是否发生在服务器端应用程序和 Silverlight 客户端的范围之外？
我只是选择将输出缓存与 RIA 服务结合使用，并设置合理的缓存过期时间，以确保以合理的时间间隔合并更改。
http://blogs.msdn .com/b/digital_ruminations/archive/2011/01/05/ria-services-output-caching.aspx
The first problem you face with any solution is synchronization when any of these 50 tables change. How would you even know if the change occurs outside the scope of both the server-side app and the Silverlight client?
I would simply opt to use output caching with RIA Services and put a reasonable cache expiration in place that ensures changes are incorporated on a somewhat reasonable interval.
http://blogs.msdn.com/b/digital_ruminations/archive/2011/01/05/ria-services-output-caching.aspx