将数据库表连接到Appfabric缓存 [英] Connecting Database Table to Appfabric Cache

问题描述

如何使用appfabric缓存连接到数据库表，以便在将任何记录添加到表或当时删除时，它将具有更新的数据 缓存自动更新。还有什么方法可以在该缓存上编写查询。

How to use appfabric cache to connect to database table so that it will have the updated data when any record is added to table or deleted at that time  cache gets updated automatically. Also is there any way to write query on that cache.

推荐答案

I有一个关于使用AppFabric缓存存储目录数据的网络广播：
http://www.cloudcasts.net /ViewWebcast.aspx?webcastid=2521388450450962015

I have a webcast on using the AppFabric cache for storing catalog data: http://www.cloudcasts.net/ViewWebcast.aspx?webcastid=2521388450450962015

在数据库中删除或修改项目时，添加代码以删除和更新缓存中的项目应该相当容易。

It should be fairly easy to add code to remove and update items in the cache when they are deleted or modified in the database.

至于查询缓存，据我所知你必须根据缓存键选择数据，这样你就可以根据主键选择单个项目，而不是基于一系列对象选择关于特定查询。

As for queryting the cache as far as I know you have to select data based on the cache key, so you can select single items based on a primary key, but not a range of objects based on a specific query.

问候，

Alan

这篇关于将数据库表连接到Appfabric缓存的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！