Hi,
   Previously we have seen how to retrieve the datafrom MongoDB using C# by passing single value as filter, Here we are going to see retrieve particular records from MongoDB by passing multiple filters using $and (or) & to the find() command. The below code returns the document of ‘ProductName’ as ‘WH-208’ and ‘Price’ as ‘9.20’.

C#:  .Net 4.5 and MongoDB 2.0

using System;
using System.Collections.Generic;
using System.Threading.Tasks;
using MongoDB.Bson;
using MongoDB.Driver;
using MongoDB.Driver.Core;
  
namespace RetrivFindAnd
{
  class Program
   {
     static void Main(string[] args)
      {
          
        CallMain(args).Wait();
        Console.ReadLine();
      }
     static async Task CallMain(string[] args)
     {
      var conString = "mongodb://localhost:27017";
      var Client = new MongoClient(conString);
      var DB = Client.GetDatabase("test");
      var collection = DB.GetCollection<BsonDocument>("store");
      var builder = Builders<BsonDocument>.Filter;
      var filt = builder.Eq("Price", "9.20") & builder.Eq("ProductName","WH-208");
      var list =await collection.Find(filt).ToListAsync();

      foreach (var doc in list)
       {
           Console.Write(doc);
       }
     }
   }
}