If I call one of my methods with a CacheResult attribute on them from my test page, the caching works fine (whether I call the per item one or the whole collection one). If I call a method on the Dal that in turn calls the per item one, suddenly my cache is not used (Sql Profiler trace confirms and does the SP call each time). This is strange.
Also I find that Spring creates a separate cache entry for each collection value individually right when the main collection is requested. This seems like a waste of resources and we have a cache viewer for inspecting the cache and this bloats the list of items in it greatly. If the main collection with all the items is requested is there no way for Spring to simply retrieve the individual Myobject right from the cached collection?
Spring Config
<!-- Cache aspect -->
<object id="CacheAspect" type="Spring.Aspects.Cache.CacheAspect, Spring.Aop"/>
<object id="AspNetCache" type="Spring.Caching.AspNetCache, Spring.Web"/>
<!-- Apply aspects to DAOs -->
<!-- Spring object name, not your c# code name and it's case sensitive! -->
<object type="Spring.Aop.Framework.AutoProxy.ObjectNameAutoProxy Creator, Spring.Aop">
<property name="ObjectNames">
<list>
<value>myobjectDal</value>
</list>
</property>
<property name="InterceptorNames">
<list>
<value>CacheAspect</value>
</list>
</property>
</object>
<db:provider id="dbProvider"
provider="SqlServer-2.0"
connectionString="blahblah"/>
<object id="adoTemplate" type="Spring.Data.Core.AdoTemplate, Spring.Data">
<property name="DbProvider" ref="dbProvider"/>
</object>
<object id="myobjectDal" type="MyNs.SpringTest.MyobjectDal, MyNs">
<property name="AdoTemplate" ref="adoTemplate"/>
</object>
Dal
namespace MyNs.SpringTest
{
public class MyobjectDal : AdoDaoSupport, IMyobjectDal
{
[CacheResult("AspNetCache", "'Myobject'", TimeToLive = "0:1:0")]
[CacheResultItems("AspNetCache", "'Myobject.MyobjectID=' + MyobjectID", TimeToLive = "0:1:0")]
[CacheResultItems("AspNetCache", "'Myobject.Name=' + Name", TimeToLive = "0:1:0")]
public Myobject GetMyobjects()
{
Myobject results = new Myobject();
IList list = AdoTemplate.QueryWithRowMapper(CommandType.StoredP rocedure, "dbo.MyobjectListGet", myobjectMapper);
foreach (Myobject d in list)
{
results.Add(d);
}
return results;
}
[CacheResult("AspNetCache", "'Myobject.MyobjectID=' + #myobjectID", TimeToLive = "0:1:0")]
public Myobject GetMyobject(int myobjectID)
{
return (Myobject)AdoTemplate.QueryForObject(CommandType.S toredProcedure,
"dbo.MyobjectListGet",
myobjectMapper, "myobjectID", DbType.Int32, 0, myobjectID);
}
[CacheResult("AspNetCache", "'Myobject.Name=' + #name", TimeToLive = "0:1:0")]
public Myobject GetMyobject(string name)
{
return (Myobject)AdoTemplate.QueryForObject(CommandType.S toredProcedure,
"dbo.MyobjectListGet",
myobjectMapper, "name", DbType.String, 0, name);
}
public string GetSiteName(int myobjectID, string origin)
{
// origin stuff removed, it fails to use the cache even returning a simple property while GetMyojbect() called from outside the Dal
// uses the cache properly. strange
Myobject d = GetMyobject(myobjectID);
return d.Name;
}
}
}
Test Page
IApplicationContext ctx = ContextRegistry.GetContext();
IMyobjectDal dal = (IMyobjectDal)ctx.GetObject("myobjectDal", typeof(IMyobjectDal));
string siteName = dal.GetMyobject(1).Name; // pulled from cache properly
Response.Write(String.Format("name again: {0} timestamp: {1}<br>", siteName, DateTime.Now.ToString()));
siteName = dal.GetSiteName(1,"blah"); // never pulled from cache! why?
Myobject d = dal.GetMyobject(); // pulled from cache properly
Response.Write(String.Format("name: {0} timestamp: {1}<br>",d[1].Name,DateTime.Now.ToString()));