我可以在Web服务方法中使用Web缓存吗? [英] can i use web cache in web service method
问题描述
嗨每个
我使用的是使用sql cache依赖的web服务方法 但问题是我总是有错误:
i use web service method which use sql cache dependency but the problem is that i alwayes have error in:
DataTable categories =(DataTable)Cache.Get(" Categories");
DataTable categories = (DataTable)Cache.Get("Categories");
和
Cache.Insert(" Categories",categories,dependency);
Cache.Insert("Categories", categories, dependency);
我不知道为什么??
但如果该方法不是网络服务,此方法可以成功运行?? !!
but this method works successfully in if the method is not a web service??!!
这是我的方法:
[
public bool GetCategories()
{
串的connectionString = ConfigurationManager.ConnectionStrings [" AttendanceConnectionString"]的ConnectionString;
public bool GetCategories()
{
string connectionString = ConfigurationManager.ConnectionStrings["AttendanceConnectionString"].ConnectionString;
///我有错误这里
    &NBSP ;       DataTable类别=(DataTable)Cache.Get(" Categories");
if(categories == null)
{
// DataTable categories = new DataTable();
使用(SqlConnection的连接=
                  &NBSP ;    新的SqlConnection(的connectionString))
             &NBSP ;  {
                   的SqlCommand命令=新的SqlCommand(QUOT; SELECT AttendanceTransactionTmpID,DepartureTime FROM dbo.Attendance_Transaction_TMP" ;,连接);
          &NBSP ;        的SqlCacheDependency依赖性=新的SqlCacheDependency(命令);
                &NBSP ;   SqlDataAdapter的适配器=新的SqlDataAdapter();
                     adapter.SelectCommand =命令;
                    数据集的数据集=新的DataSet();
                     adapter.Fill(数据集);
                 &NBSP ;  categories = dataset.Tables [0];
///i have error here
DataTable categories = (DataTable)Cache.Get("Categories");
if (categories == null)
{
// DataTable categories = new DataTable();
using (SqlConnection connection =
new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("SELECT AttendanceTransactionTmpID,DepartureTime FROM dbo.Attendance_Transaction_TMP", connection);
SqlCacheDependency dependency = new SqlCacheDependency(command);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataSet dataset = new DataSet();
adapter.Fill(dataset);
categories = dataset.Tables[0];
///我这里有错误。
             Cache.Insert(QUOT;类别" ;,类别依赖性);
                    返回true;
}
}
否则为
{
返回false;
}
///and i have error here
Cache.Insert("Categories", categories, dependency);
return true;
}
}
else
{
return false;
}
} 
}
}
}
祝福
fatma
推荐答案
您是否使用了Context.Cache类?错误是什么?
Did you use the Context.Cache class? What is the error?
这篇关于我可以在Web服务方法中使用Web缓存吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!