Skip to content

ApplyFilter does not work on join statements in LINQ #2549

Closed
@esabah

Description

@esabah

Hi
We upgraded NH from 5.2.7 to 5.3.3.
After upgrade we had an issue that ApplyFilter does not work with joins.
Same join statement working fine with version 5.2.7.

You can find testcase implementation below link.
https://github.com/esabah/NHibernateBugTest/blob/master/NHibernateBugTest/TxnDefTest.cs

TxnDefMember entity has a custom filter which applies filter on mbrId field.

ApplyFilter<MemberConditionFilter>();

But mbrId not included in sql query in 5.3.3 version.
(from txndef in session.Query<TxnDef>() join txnDefMember in session.Query<TxnDefMember>() on txndef.Guid equals txnDefMember.Id.TxnDefGuid select txnDefMember.BucketName)

same query returns 8 records in 5.3.3
and returns 4 records in 5.2.7

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions