mongodb-query.cs

async Task Main()
{
	IMongoDatabase db = new MongoClient().GetDatabase("bookStore");
	IMongoCollection<Author> authors = db.GetCollection<Author>("Authors");
		
	//Query single document
	var stephenKing = await authors
		.Find(author => author.Name == "Stephen" && author.Surname == "King")
		.SingleAsync();
	stephenKing.Dump();
		
		
	//Query multible documents
	var allAuthors = await authors
		.Find(author => true)
		.Project(author => new {
			author.Name,
			author.Surname
		})
		.ToListAsync();
	allAuthors.Dump();
		
	//Query using query builder
	var builder = Builders<Author>.Filter;
	var filter = Builders<Author>.Filter.Eq("Books.Genre", "Fantasy");
	var fantacyAuthors = await authors
		.Find(filter)
		.ToListAsync();
	fantacyAuthors.Dump();
		
}



// Define other methods and classes here
[BsonIgnoreExtraElements]
public class Author {
	public string Name { get; set; }
	public string Surname { get; set; }
	public Book[] Books { get; set; }
}
public class Book {
	public string Title { get; set; }
	public string Genre { get; set; }
	public DateTime? PublishedOn { get; set; }
	public Double? Price { get; set; }
}