Hi
I have one table, "Articles", in db with these columns:
Id (int)
Title (varchar(50))
Article (varchar(8000))
I create a mapping class:
public class ArticlesMap:ClassMap<Articles>
{
Id(x=>x.Id);
Map(x=>x.Tltle);
Map(x=>x.Article);
}
And I read the data:
var
list=_session.Query<Articles>().Cacheable().Orderby(t=>t.Title).ToList();
Ok, all works fine (also the cache), but in the first page I show (with
pagination) all articles, but I show only the Title and I use Id for create
a link. But nhibernate request also the article column... Is it possibile
to request only the Id and title?
I test with this mapping:
public class ArticlesMap:ClassMap<Articles>
{
Id(x=>x.Id);
Map(x=>x.Tltle);
Map(x=>x.Article).LazyLoad();
}
Ok, it works fine, but in the second page, when I request detail for this
article:
var list=_session.Query<Articles>().Cacheable().Where(t=>t.Id==1).ToList();
And in page I show this column, this information is not cache. Every time I
request a page, nhibernate execute a new query.
Is there some solution?
Thanks
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.
