FetchEntityCollection and supply hints to SQL Server

Posts   
 
    
yowl
User
Posts: 275
Joined: 11-Feb-2008
# Posted on: 19-Dec-2025 17:10:48   

Hi,

How can I get a NOLOCK hint on the root entity (LLBLGen 5.12)

                var prefetchPath = new PrefetchPath2(EntityType.ClaimViewEntity);
                var miClaimPP = prefetchPath.Add(ClaimViewEntity.PrefetchPathMiClaimView).WithHint("NOLOCK");

This will add NOLOCK to the MiClaimView entity, but how do I get the hint on the ClaimViewEntity, it is only possible if I start with a QueryFactory ?

Thanks,