--
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 nhusers+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nhusers/b0f49396-d6a3-406d-98de-404e0eeeea79n%40googlegroups.com.
We upgraded on to NHibernate 5.3.5 from 3 and Fluent NHibernate to 3.1
public class ReasonDataAccessorAssignment
{
public virtual int Id { get; protected internal set; }
public virtual Reason Reason{ get; protected internal set; }
}
public class Reason
{
public virtual int ID { get; protected internal set; }
public virtual IList<ReasonDataAccessorAssignment> ReasonDataAccessorAssignments { get; protected internal set; }
}
Class map:
public class ReasonMap : ClassMap<Reason>
{
public ReasonMap()
{
var tableMeta = "Reason";
this.Table(tableMeta);
Id(x => x.ID).Column("Reason_id").GeneratedBy.Identity();
HasMany(x => x.ReasonDataAccessorAssignments)
.KeyColumn("Reason_id")
.Cascade.AllDeleteOrphan()
.Not.LazyLoad()
.BatchSize(100);
}
}
Repository call:
Var reasons = (from s in _session.Query<Reason>()
where s.ReasonDataAccessorAssignments != null
select s).ToList();
This query is NOT generating ReasonDataAccessorAssignment table as LEFT OUTER JOIN with latest version
Previous version NHibernate 3 is generating LEFT OUTER JOIN with above query
To view this discussion on the web visit https://groups.google.com/d/msgid/nhusers/CAHOuc7PmKt1m9gfS8O8m-x91uq9Hk%3D57gFXNcDC0--8YvLzrpA%40mail.gmail.com.
We upgraded on to NHibernate 5.3.5 from 3
public class ReasonDataAccessorAssignment
{
public virtual int Id { get; protected internal set; }
public virtual Reason Reason{ get; protected internal set; }
}
public class Reason
{
public virtual int ID { get; protected internal set; }
public virtual IList<ReasonDataAccessorAssignment> ReasonDataAccessorAssignments { get; protected internal set; }
}
Class map:
public class ReasonMap : ClassMap<Reason>
{
public ReasonMap()
{
var tableMeta = "Reason";
this.Table(tableMeta);
Id(x => x.ID).Column("Reason_id").GeneratedBy.Identity();
HasMany(x => x.ReasonDataAccessorAssignments)
.KeyColumn("Reason_id")
.Cascade.AllDeleteOrphan()
.Not.LazyLoad()
.BatchSize(100);
}
}
Repository call:
Var reasons = (from s in _session.Query<Reason>()
where s.ReasonDataAccessorAssignments != null
select s).ToList();
This query is NOT generating ReasonDataAccessorAssignment table as LEFT OUTER JOIN with latest version
Previous version NHibernate 3 is generating LEFT OUTER JOIN with above query
To view this discussion on the web visit https://groups.google.com/d/msgid/nhusers/CAHOuc7PmKt1m9gfS8O8m-x91uq9Hk%3D57gFXNcDC0--8YvLzrpA%40mail.gmail.com.
We upgraded on to NHibernate 5.3.5 from 3
public class ReasonDataAccessorAssignment
{
public virtual int Id { get; protected internal set; }
public virtual Reason Reason{ get; protected internal set; }
}
public class Reason
{
public virtual int ID { get; protected internal set; }
public virtual IList<ReasonDataAccessorAssignment> ReasonDataAccessorAssignments { get; protected internal set; }
}
Class map:
public class ReasonMap : ClassMap<Reason>
{
public ReasonMap()
{
var tableMeta = "Reason";
this.Table(tableMeta);
Id(x => x.ID).Column("Reason_id").GeneratedBy.Identity();
HasMany(x => x.ReasonDataAccessorAssignments)
.KeyColumn("Reason_id")
.Cascade.AllDeleteOrphan()
.Not.LazyLoad()
.BatchSize(100);
}
}
Repository call:
Var reasons = (from s in _session.Query<Reason>()
where s.ReasonDataAccessorAssignments != null
select s).ToList();
This query is NOT generating ReasonDataAccessorAssignment table as LEFT OUTER JOIN with latest version
Previous version NHibernate 3 is generating LEFT OUTER JOIN with above query