Add support for $in where the property is an array

[gabrielduford]

Hi,
I'd like to implement the following using FluentMongo (this is a LINQPad query):

void Main() 
{
    MongoServer mongo = MongoServer.Create(new MongoConnectionStringBuilder() { Server = new MongoServerAddress("localhost") } );
    MongoDatabase database = mongo["Demo"];
    MongoCollection<Employee> employeeCollection = database.GetCollection<Employee>("Employees");

    Employee emp1 = new Employee() { Name = "Bob" };
    emp1.Departments.Add("Dep1");
    emp1.Departments.Add("Dep2");

    Employee emp2 = new Employee() { Name = "Binette" };
    emp2.Departments.Add("Dep2");
    emp2.Departments.Add("Dep3");

    employeeCollection.InsertBatch(new[] { emp1, emp2 });

    IEnumerable<Employee> searchResult =
        employeeCollection
        .Find(Query.In("Departments", BsonArray.Create(new [] { "Dep1", "Dep2" })));

    searchResult.Dump(); // LINQPad dumps the result to the output.

    employeeCollection.RemoveAll();
}

class Employee
{
    public Employee()
    {
        Departments = new List<string>();
    }

    public ObjectId Id { get; set; }
    public string Name { get; set; }
    public List<string> Departments
    { 
        get; 
        private set; 
    }
}

Intuitively, I would implement the query like this in FluentMongo, but I get a NotSupportException:
IEnumerable searchResult2 =
employeeCollection
.AsQueryable()
.Where(o => o.Departments.Intersect(new [] { "Dep1", "Dep2" }).Any());

Is there a better way to implement this kind of query in FluentMongo?
Thanks,

gabriel

[gabrielduford]

Documentation for what I am trying to achieve:
http://www.mongodb.org/display/DOCS/Advanced+Queries#AdvancedQueries-ValueinanArray

gabriel

[ghost]

I would also like to request the same feature, or if otherwise possible would like to know how this can be achieved using fluent mongo?

[craiggwilson]

This should already be possible. See https://github.com/craiggwilson/fluent-mongo/blob/master/src/FluentMongo.Tests/Linq/MongoQueryProviderTests.cs#L172.

[gabrielduford]

Hummm... The case is not the same. My case is about supporting "Enumerable.Intersect".