Prefetch extensions for the Linq Provider in LLBLGen.

Each time you build prefetches for LLBLGen Linq queries the syntax can be a bit much. These extensions add some simplified prefetch building logic.

Instead of

metaData.Project
    .WithPath(path => path.Prefetch<ProjectCompanyLinkEntity>(p => p.ProjectCompanyLinks)
        .SubPath(subPath1 => subPath1.Prefetch<CompanyEntity>(pcl => pcl.Company)
            .SubPath(subPath2 => subPath2.Prefetch<CompanyAddressEntity>(c => c.CompanyAddresses)))
        .SubPath(subPath1 => subPath1.Prefetch<ContactEntity>(Pcl => pcl.Contact)
            .SubPath(subPath2 => subPath2.Prefetch<ContactTypeEntity>(c => c.ContactType))));

You can just write

metaData.Project
    .With(p => p.ProjectCompanyLinks
                .With(pcl => pcl.Company
                                .With(c => c.CompanyAddresses),
                      pcl => pcl.Contact.ContactType));

There is full support for filtering, sorting and explicit inclusion or exclusion of fields on entity and entity collection properties within a prefetch expression by using:-

• FilterBy
• SortBy
• SortByDescending
• Include
• Exclude

It is also possible to limit the number of rows from an entity collection properties within a prefetch expression by using:-

• LimitTo

The test suite included in the source is based on the standard Northwind database tests from LLBLGen Pro and is included with kind permission.

Check this out on Nuget: https://www.nuget.org/packages/LLBLGen.Linq.Prefetch