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
On Wed, Dec 16, 2020 at 3:59 PM Oskar Berggren <[email protected]>
wrote:
> Your query example seems seems odd too. The variable `jobs` should be
> typed as IList<TAggregate> but then you try to access `jobs.Departments` -
> but `Departments` is hardly defined by the IList<T> interface, so what is
> really going on?
>
> Den ons 16 dec. 2020 kl 11:27 skrev Oskar Berggren <
> [email protected]>:
>
>> Where is the HasMany() mapping?
>>
>> Also, you have put Inverse on the References() mapping. I don't think
>> I've ever tried that, I've only ever put Inverse() on the HasMany-side.
>>
>> Den ons 16 dec. 2020 kl 10:08 skrev Venkata Krishna Reddy Sangu <
>> [email protected]>:
>>
>>> Team, Any idea on this issue?
>>> Default left outer join is not getting created for Hasmany() mapping.
>>> Previous version prior to NH 5.3 is working fine.
>>>
>>> On Monday, December 14, 2020 at 11:08:12 PM UTC+5:30 Venkata Krishna
>>> Reddy Sangu wrote:
>>>
>>>> Hi Team,
>>>> I have a mapping like below. And Job has 'Department' as property.
>>>> References(x => x.Job)
>>>> .Column(tableMeta.Job_id)
>>>> .Not.LazyLoad().Inverse()
>>>> .Cascade.None();
>>>>
>>>> Query as:
>>>> empIds - input integer ids
>>>> var jobs = _session.Query<TAggregate>() .Where(e =>
>>>> empIds.Contains(e.EmployeeID))
>>>> .ToList());
>>>> var depts = jobs.Departments.
>>>> here departments coming as null. Because there is no eagar loading
>>>> happenings.
>>>>
>>>> How my mappings should be in order to generate left outer join for
>>>> other entities we used in the property.
>>>>
>>>>
>>>> --
>>> 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 view this discussion on the web visit
>>> https://groups.google.com/d/msgid/nhusers/b0f49396-d6a3-406d-98de-404e0eeeea79n%40googlegroups.com
>>> <https://groups.google.com/d/msgid/nhusers/b0f49396-d6a3-406d-98de-404e0eeeea79n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>> --
> 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 view this discussion on the web visit
> https://groups.google.com/d/msgid/nhusers/CAHOuc7PmKt1m9gfS8O8m-x91uq9Hk%3D57gFXNcDC0--8YvLzrpA%40mail.gmail.com
> <https://groups.google.com/d/msgid/nhusers/CAHOuc7PmKt1m9gfS8O8m-x91uq9Hk%3D57gFXNcDC0--8YvLzrpA%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>
--
Regards
Venkata Krishna Reddy Sangu
+91 9666121219
BlueYonder
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/nhusers/CAHMW07bwia0krUB91iwegH5iEXwBOMhLCa7k9zi5mEMjzSxgGw%40mail.gmail.com.
