Entity Framework and MongDB sources in the same query

[CJS2025]

Hi, in my graphql query I want to provide some types that are sourced from SQL server via Entity Framework 6 and some that are sourced from MongoDB via the Mongo.Driver.
I am using HotChocolate.AspNetCore, HotChocolate.Data.EntityFramework and HotChocolate.Data.MongoDb all at v13.0.5.
I am experiencing problems with pagination in that in order to get it to work with MongoDB I have to use .AddMongoDbPagingProviders() in the pipeline but when I do this the pagination breaks for the Entity Framework types with an exception like:

"The provided source Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1[[AI.ProjectModels.Models.PPS.SQL.Worksite, AI.ProjectModels, Version=1.0.274.0, Culture=neutral, PublicKeyToken=null]] is not supported for mongo paging"

which suggests that the MongoDB paging is being engaged for all types.

My pipeline looks like:

.AddGraphQLServer()
                .AddProjections()
                .AddSorting()
                .AddFiltering()
                .RegisterDbContext<AIDataContext>() 
                .AddType<WorksiteObjectType>()  
                .AddType<OracleProjectGraphQL>()
                .AddQueryType<Query>()
                .AddMongoDbFiltering()
                .AddMongoDbSorting()
                .AddMongoDbPagingProviders(defaultProvider:false, providerName:"MongoDB")
                ;

and my query is

using AI.ProjectModels.Models.NR;
using HotChocolate13WithEF.Data;
using HotChocolate13WithEF.Model;
using MongoDB.Driver;

namespace HotChocolate13WithEF
{
    public class Query
    {

        [UsePaging(IncludeTotalCount = true, DefaultPageSize = 10, MaxPageSize = int.MaxValue - 1)]
        [UseProjection]
        [UseFiltering]
        [UseSorting]
        public IEnumerable<Worksite>? GetWorksites(AIDataContext context)
        {
            return context.Worksites;
        }

        [UsePaging(ProviderName = "MongoDb", DefaultPageSize = 10, MaxPageSize = int.MaxValue - 1)]
        [UseProjection]
        [UseSorting]
        [UseFiltering]
        public IExecutable<OracleProjectGraphQL> GetOracleProjects([Service] IMongoCollection<OracleProjectGraphQL> collection)
        {
            return collection.AsExecutable();
        }
    }
}

Can anyone suggest the best approach for doing this? I have not been able to find much information by searching.

Many thanks