Try this:
DetachedCriteria crit =
DetachedCriteria.For<Category>()
.SetCacheable(true)
.AddOrder(new Order("SortOrder", true));
Category[] categories = ActiveRecordMediator<Category>.FindAll();
On a side not why are you trying to pull all categories? Just pull them as
they are needed (using find by primary key)...they will be cached as they
are pulled and subsequent calls will get the cached version.
Dan
Checkout my blog @ http://blog.agilejedi.com
Checkout my homepage @ http://www.agilejedi.com
On Wed, Feb 4, 2009 at 9:38 PM, jasonsirota <[email protected]> wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
