using System;
using System.Collections.Generic;
using MongoDB.Bson;
using MongoDB.Bson.Serialization.Attributes;
using MongoDB.Driver;
using MongoDB.Driver.Linq;namespace BugReport
{
    class Program
    {
        class Movie
        {
            [BsonElement("id"), BsonId]
            public ObjectId Id { get; set; }
            [BsonElement("title")]
            public string Title { get; set; }
            [BsonElement("directors")]
            public List<string> Directors { get; set; }
            [BsonElement("runtime")]            [BsonDefaultValue(0)]
            public int Runtime { get; set; }
        }

        static void Main(string[] args)
        {
            var connectionString = "mongodb://localhost";
            var clientSettings = MongoClientSettings.FromConnectionString(connectionString);
            clientSettings.LinqProvider = LinqProvider.V2;
            var mongoClient = new MongoClient(clientSettings);
            var db = mongoClient.GetDatabase("bug_report_jla");

            var moviesBson = db.GetCollection<BsonDocument>("movies");
            moviesBson.DeleteMany(new BsonDocument());
            moviesBson.InsertOne(new BsonDocument { { "title", "Hannibal" }, { "directors", new BsonArray { "Ridley Scott" } } });            
            Console.WriteLine(moviesBson.AsQueryable().ToList().Count);

            var moviesLinq = db.GetCollection<Movie>("movies");

            var m1 = moviesLinq.AsQueryable()
                .SelectMany(m => m.Directors, (m, d) => new { Director = d, Title = m.Title })
                .Where(m => m.Director == "Ridley Scott")
                .ToList();

            var m2 = moviesLinq.AsQueryable()
                .SelectMany(m => m.Directors, (m, d) => new { Director = d, Title = m.Title, Runtime = m.Runtime })
                .Where(m => m.Director == "Ridley Scott")
                .ToList();
            ;
            Console.ReadKey();
        }
    }
}