Add Support for Dynamic Collection Names in LINQ Queries

[anilsnl]

Hello,

Currently, when using the Couchbase.Linq library, it is not possible to dynamically specify a collection name while executing LINQ queries. This is a feature commonly available in MongoDB’s .NET driver through methods like IMongoDatabase.GetCollection(), which allows developers to dynamically pass the collection name and immediately execute LINQ queries using AsQueryable().

For example, in MongoDB, one can write:

var collection = database.GetCollection<User>(User.GetCollectionName(appCode)).AsQueryable();
var users = collection.Where(u => u.Role == "admin").ToList();

This flexibility is extremely useful in multi-tenant applications where collection names are determined at runtime based on the tenant or application context.

In Couchbase, achieving similar functionality requires using N1QL queries and dynamic string interpolation, which lacks the type safety and readability of LINQ queries.

Feature Request:
Add support for dynamically specifying collection names within LINQ queries in the Couchbase.Linq library. For instance, it would be beneficial to have an API like:

var context = new BucketContext(bucket);
var collection = context.GetCollection<User>("dynamicCollectionName").AsQueryable();
var users = collection.Where(u => u.Role == "admin").ToList();

This feature would greatly enhance developer productivity, improve type safety, and align Couchbase LINQ capabilities with other database drivers that support dynamic collection names.

Thank you for considering this request!

[chullybun]

Hi, I came here looking for the same functionality; good news / bad news - it is there, but internal :-(

We just need the team to make the method public as follows: https://github.com/couchbaselabs/Linq2Couchbase/blob/6b63364d429079531b3bedeb5d7adbb100b898fc/Src/Couchbase.Linq/BucketContext.cs#L76C74-L76C93

public IQueryable<T> Query<T>(string scope, string collection, BucketQueryOptions options = BucketQueryOptions.None)

In the meantime, you can get it to work through some reflection wizardry as follows:

var bc = new BucketContext(...
var mi = typeof(BucketContext).GetMethod(nameof(BucketContext.Query), BindingFlags.Instance | BindingFlags.NonPublic, [typeof(string), typeof(string), typeof(BucketQueryOptions)])!;
var q = (IQueryable<TModel>)mi.MakeGenericMethod(typeof(TModel)).Invoke(bc, ["ScopeName", "CollectionName", new BucketQueryOptions()])!;
q.Where(....

Cheers...

[1968martino]

I had the same frustration so i add the next code to the component and this is what i wanted

        /// <summary>
        /// Queries the current <see cref="IBucket" /> for entities of type T. This is the target of
        /// a LINQ query and requires that the associated JSON document have a type property that is the same as T.
        /// </summary>
        /// <typeparam name="T">An entity or POCO representing the object graph of a JSON document.</typeparam>
        /// <param name="scope">Add Scope Name</param>
        /// <param name="collection">Add Collection Name</param>
        /// <param name="options">Options to control the returned query.</param>
        /// <returns><see cref="IQueryable{T}" /> which can be used to query the bucket.</returns>
        IQueryable<T> QueryFrom<T>(string scope, string collection, BucketQueryOptions options = BucketQueryOptions.None);

        public IQueryable<T> QueryFrom<T>(string scope, string collection, BucketQueryOptions options = BucketQueryOptions.None)
        {
            IQueryable<T> query = new CollectionQueryable<T>(Bucket.Scope(scope).Collection(collection), QueryProvider);

            if (!options.HasFlag(BucketQueryOptions.SuppressFilters))
            {
                query = _documentFilterManager.ApplyFilters(query);
            }

            return query;
        }

and call it like this

var items = context.QueryFrom<blog>("blogs", "blog").ToList();

or

var items = context.QueryFrom<dynamic>("blogs", "blog").ToList();

[jeffrymorris]

You might want to take a look at the Couchbase EF Core provider: https://docs.couchbase.com/efcore-provider/current/overview.html

Jeff