Some more cache related problems. I am having a problem getting the
results of associated or child entities to be loaded into the
nhibernate cache along with the root entity when using the Expand()
method. The root entity loads fine though. So the following:
var query = session.Linq<Promoter>();
query.Expand(x=>x.PromoterType);
query.QueryOptions.SetCacheMode(CacheMode.Normal).SetCachable(true);
promoters = query.ToList();
will cache the promoters but not the PromoterType values. This is
obviously an issue as I don't want to set the join's and eager loading
in the mapping files (which solves the problem by
using .Not.LazyLoad() ). I get an
NHibernate.LazyInitializationException exception as the item in not
available. Below is my Test and mapping files. Any tips greatly
appreciated.
[Test]
public void Can_Cache_Associations_Or_Children()
{
List<Promoter> promoters;
using (ISession session = SessionFactory.OpenSession())
{
var query = session.Linq<Promoter>();
query.Expand(x=>x.PromoterType);
query.QueryOptions.SetCacheMode(CacheMode.Normal).SetCachable(true);
promoters = query.ToList();
}
Console.WriteLine("1st Query");
foreach (var promoter in promoters)
{
Console.WriteLine();
Console.WriteLine("Promoter:" + promoter.Name);
Console.WriteLine("Type:" +
promoter.PromoterType.Name);
}
Console.WriteLine("_______________________________________");
Console.WriteLine();
Console.WriteLine("2nd Query");
using (ISession session = SessionFactory.OpenSession())
{
var query = session.Linq<Promoter>();
query.Expand(x => x.PromoterType);
query.QueryOptions.SetCacheMode(CacheMode.Normal).SetCachable(true);
promoters = query.ToList();
}
foreach (var promoter in promoters)
{
Console.WriteLine();
Console.WriteLine("Promoter:" + promoter.Name);//
fails with NHibernate.LazyInitializationException :
Initializing[LinqCache.Entities.PromoterType#3c907ebb-9a4d-4490-bafe-
a220d14bf962]-Could not initialize proxy - no Session
Console.WriteLine("Type:" +
promoter.PromoterType.Name);
}
}
Mapping:
public PromoterMap()
{
Table("Promoters");
Cache.NonStrictReadWrite();
Id(x => x.Id, "Id")
.UnsavedValue("00000000-0000-0000-0000-000000000000")
.GeneratedBy.GuidComb();
OptimisticLock.Version();
Version(entity => entity.Version);
Map(x => x.Name);
References(x => x.PromoterType,
"PromoterTypeId");// .Not.LazyLoad(); adding the Not.LazyLoad solves
the problem
}
and
public PromoterTypeMap()
{
Cache.NonStrictReadWrite();
Table("PromoterType");
Id(x => x.Id, "Id")
.UnsavedValue("00000000-0000-0000-0000-000000000000")
.GeneratedBy.GuidComb();
OptimisticLock.Version();
Version(entity => entity.Version);
Map(x => x.Name);
}
--
You received this message because you are subscribed to the Google Groups
"nhusers" 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/nhusers?hl=en.
