Okay I got this to work with this set of code:
ISessionFactoryHolder holder =
ActiveRecordMediator.GetSessionFactoryHolder();
ISession session = holder.CreateSession(typeof(Category));
ICriteria crit = session.CreateCriteria(typeof(Category));
crit.SetCacheable(true);
crit.AddOrder(new Order("SortOrder",true));
IList list = crit.List();
Category[] defaultCategories = new Category[list.Count];
list.CopyTo(defaultCategories, 0);
I feel like this is too many lines of code, is there some built in AR
functions. I feel like there should be something in AR
like:
Criteria crit = Category.CreateCriteria(); (a method of
ActiveRecordBase<Category>)
crit.SetCacheable(true);
crit.AddOrder(new Order("SortOrder",true));
Category.FindAll(crit);
or even better, overloads for find all
FindAll(bool cacheable)
Maybe I'm missing something....
On Feb 4, 5:11 pm, jasonsirota <[email protected]> wrote:
> So Ayende,
>
> Why isn't FindAll() cacheable? It seems like any time you'd want to do
> a FindAll(), you'd want them to be cacheable...shouldn't all the
> activerecord generated queries be associated to a cache region, or are
> they already?
>
> Jason
>
> On Feb 3, 6:20 pm, Ayende Rahien <[email protected]> wrote:
>
> > you need to enable query caching as well, and you need to mark the query as
> > cachable.
> > I don't think you can do it using FindAll
>
> > On Wed, Feb 4, 2009 at 2:41 AM, jasonsirota <[email protected]> wrote:
>
> > > For reference, here's my config:
>
> > > <activerecord isWeb="true" isDebug="false"
>
> > > threadinfotype="Castle.ActiveRecord.Framework.Scopes.HybridWebThreadScopeInfo,
> > > Castle.ActiveRecord">
> > > <config>
> > > <add key="connection.driver_class"
> > > value="NHibernate.Driver.SqlClientDriver" />
> > > <add key="dialect"
> > > value="NHibernate.Dialect.MsSql2005Dialect" />
> > > <add key="connection.provider"
> > > value="NHibernate.Connection.DriverConnectionProvider" />
> > > <add key="connection.connection_string" value="XXX"/>
> > > <add key="proxyfactory.factory_class"
> > > value="NHibernate.ByteCode.Castle.ProxyFactoryFactory,
> > > NHibernate.ByteCode.Castle" />
> > > <add key="cache.provider_class"
> > > value="NHibernate.Caches.SysCache.SysCacheProvider,NHibernate.Caches.SysCache"
> > > /
>
> > > <add key="relativeExpiration" value="300" />
> > > </config>
> > > </activerecord>
>
> > > On Feb 3, 4:37 pm, jasonsirota <[email protected]> wrote:
> > > > I thought that you just had to wrap it in SessionScope, and
> > > > SessionScope is enabled for the full httprequest using the httpmodule
>
> > > > However, just to be safe, I wrapped it in a transaction:
>
> > > > Category[] defaultCategories;
> > > > using (new TransactionScope(OnDispose.Commit))
> > > > {
> > > > defaultCategories = Category.FindAll();
> > > > }
>
> > > > However, I still get the multiple db calls.
>
> > > > On Feb 3, 4:23 pm, Stefan Sedich <[email protected]> wrote:
>
> > > > > Do you not need to wrap your call to get all in a transaction? I
> > > > > thought second level cache was only commited on commit of a
> > > > > transaction?
>
> > > > > Cheers
> > > > > Stefan
>
> > > > > On Wed, Feb 4, 2009 at 10:15 AM, jasonsirota <[email protected]>
> > > wrote:
>
> > > > > > After wrestling with the trunk version of ActiveRecord and
> > > > > > NHibernate
> > > > > > and NH-Contrib version numbers I finally got cache support enabled
> > > for
> > > > > > the AR project, however I'm having trouble getting it to work.
>
> > > > > > The call is something like:
>
> > > > > > Category.FindAll(new Order("SortOrder"),true)
>
> > > > > > which returns a list of category sorted by the db field "SortOrder".
>
> > > > > > I've enabled caching on the Category object like:
>
> > > > > > [ActiveRecord("Categories", Cache=CacheEnum.ReadOnly)]
> > > > > > public class Category
> > > > > > ...
>
> > > > > > However, each time the page loads, it requeries the database instead
> > > > > > of pulling the resulting list from the cache.
>
> > > > > > SELECT this_.CategoryID as CategoryID4_0_, this_.Description as
> > > > > > Descript2_4_0_, this_.SortOrder as SortOrder4_0_, this_.Type as
> > > > > > Type4_0_ FROM BudgeterCategories this_ ORDER BY this_.SortOrder asc
>
> > > > > > Any ideas?
> > > > > > Jason
>
> > > > > --
> > > > > Stefan Sedich
> > > > > Software Developerhttp://weblogs.asp.net/stefansedich
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Castle Project Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en
-~----------~----~----~----~------~----~------~--~---
