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,

Yes, you have to specify the hint on the main query. With a prefetch path, the sub-path nodes are the only place to specify the hint for that additional query as the node represents the additional query.

Thanks, that's great.