NHibernate enable lazy loading for single query

Question

In .hbm mapping file, i have the following setting:

<set name="Fields" table="Fields" lazy="false" cascade="all" inverse="false">

/.../

The lazy loading for this collection is globally disabled

Is it a way to "locally" enable lazy loading only for single Linq query?

The HBM mapping file must remains intact.

score 1 · Accepted Answer · answered Feb 20 '20 at 15:57

Well, I don't think it is achievable by LINQ, but you can use NHibernate's ICriteria to achieve what you want. An example could be like below.

ISession.CreateCriteria<Entity>()
        .SetFetchMode("Fields", FetchMode.Lazy)
        .List<Entity>();

1 Answers1