Install-Package mongocsharpdriver

  public class Author
    {
        public ObjectId Id { get; set; }
        public string Name { get; set; }
    }

public class Language
    {
        public ObjectId Id { get; set; }
        public string Name { get; set; }
    }

  public class Book
    {
        public ObjectId Id { get; set; }
        public string Title { get; set; }
        public string ISBN { get; set; }
        public int Price { get; set; }
        public List<Author> Authors { get; set; }
        public Language Language { get; set; }
    }

           var book =new Book()
           {
               Title = "Gone With Wind",
               ISBN = "43442424",
               Price = 50000,
               Language = new Language()
               {
                  Name = "Persian"
               },
               Authors = new List<Author>()
               {
                   new Author()
                   {
                       Name = "Margaret Mitchell"
                   },
                     new Author()
                   {
                       Name = "Ali Mahboobi (Translator)"
                   },
               }
           };

var client = new MongoClient();

 string connectionString = "mongodb://localhost:27017";
            MongoClientSettings settings = MongoClientSettings.FromUrl(new MongoUrl(connectionString));
            var client = new MongoClient(settings);

var db = client.GetDatabase("publisher");

var collection = db.GetCollection<Book>("books");

collection.InsertOneAsync(book);

       var client = new MongoClient();
            var db = client.GetDatabase("publisher");
            db.DropCollection("books");
            var collection = db.GetCollection<Book>("books");
            
            var book =new Book()
           {
               Title = "Gone With Wind",
               ISBN = "43442424",
               Price = 50000,
               Year = 1936,
               LastStock = DateTime.Now.AddDays(-13),
               Language = new Language()
               {
                  Name = "Persian"
               },
               Authors = new List<Author>()
               {
                   new Author()
                   {
                       Name = "Margaret Mitchell"
                   },
                     new Author()
                   {
                       Name = "Ali Mahboobi (Translator)"
                   },
               }
           };

            var book2 = new Book()
            {
                Title = "Jane Eyre",
                ISBN = "87897897",
                Price = 60000,
                Year = 1847,
                LastStock = DateTime.Now.AddDays(-5),
                Language = new Language()
                {
                    Name = "English"
                },
                Authors = new List<Author>()
               {
                   new Author()
                   {
                       Name = "Charlotte Brontë"
                   },
                   
               }
            };


            var book3 = new Book()
            {
                Title = "White Fang",
                ISBN = "43442424",
                Price = 50000,
                Year = 1936,
                LastStock = DateTime.Now.AddDays(-13),
                Language = new Language()
                {
                    Name = "English"
                },
                Authors = new List<Author>()
               {
                   new Author()
                   {
                       Name = "Jack London"
                   },
                     new Author()
                   {
                       Name = "Philippe Mignon"
                   },
               }
            };

            var book4 = new Book()
            {
                Title = "The Lost Symbol",
                ISBN = "43442424",
                Price = 3500000,
                Year = 2009,
                LastStock = DateTime.Now.AddDays(-17),
                Language = new Language()
                {
                    Name = "Persian"
                },
                Authors = new List<Author>()
               {
                   new Author()
                   {
                       Name = "Dan Brown"
                   },
                     new Author()
                   {
                       Name = "Mehrdad"
                   },
               }
            };

            var book7 = new Book()
            {
                Title = "The Lost Symbol",
                ISBN = "43442424",
                Price = 47000000,
                Year = 2009,
                LastStock = DateTime.Now.AddDays(-56),
                Language = new Language()
                {
                    Name = "Persian"
                },
                Authors = new List<Author>()
               {
                   new Author()
                   {
                       Name = "Dan Brown"
                   },
                     new Author()
                   {
                       Name = "Mehrdad"
                   },
               }
            };
            var book5= new Book()
            {
                Title = "The Help",
                ISBN = "45345e3er3",
                Price = 9000000,
                Year = 2009,
                LastStock = DateTime.Now.AddDays(-2),
                Language = new Language()
                {
                    Name = "Enlish"
                },
                Authors = new List<Author>()
               {
                   new Author()
                   {
                       Name = "Kathryn Stockett"
                   },
                    
               }
            };

            var book6 = new Book()
            {
                Title = "City of Glass",
                ISBN = "454534545",
                Price = 500000,
                Year = 2009,
                LastStock = DateTime.Now,
                Language = new Language()
                {
                    Name = "Persian"
                },
                Authors = new List<Author>()
               {
                   new Author()
                   {
                       Name = "Cassandra Clare"
                   },
                   new Author()
                   {
                       Name = "Ali"
                   },

               }
            };
            var books = new List<Book> {book, book2, book3, book4, book5, book6,book7};

            collection.InsertManyAsync(books);

            var client = new MongoClient();
            var db = client.GetDatabase("publisher");
            var collection = db.GetCollection<Book>("books");
            
            var filter=new BsonDocument();
            var docs = collection.Find(filter).ToList();
            foreach (var book in docs)
            {
                Console.WriteLine(book.Title + " By "+ book.Authors[0].Name);
            }

Gone With Wind By Margaret Mitchell
Jane Eyre By Charlotte Brontë
White Fang By Jack London
The Lost Symbol By Dan Brown
The Help By Kathryn Stockett
City of Glass By Cassandra Clare
The Lost Symbol By Dan Brown

var filter = Builders<Book>.Filter.Eq("Year", 2009);

            var docs = collection.Find(filter).ToList();
            foreach (var book in docs)
            {
                Console.WriteLine(book.Title + " By "+ book.Authors[0].Name);
            }

The Lost Symbol By Dan Brown
The Help By Kathryn Stockett
City of Glass By Cassandra Clare
The Lost Symbol By Dan Brown

   // var filter=new BsonDocument();
            var filterBuilder = Builders<Book>.Filter;
            var filter= filterBuilder.Eq("Year", 2009) | filterBuilder.Gte("Price",700000);

            var docs = collection.Find(filter).ToList();
            foreach (var book in docs)
            {
                Console.WriteLine(book.Title + " By "+ book.Authors[0].Name);
            }

Gone With Wind By Margaret Mitchell
White Fang By Jack London
The Lost Symbol By Dan Brown
The Help By Kathryn Stockett
City of Glass By Cassandra Clare
The Lost Symbol By Dan Brown

var docs = collection.AsQueryable().Where(x => x.Year == 2009 || x.Price <= 50000).ToList();

  var sort = Builders<Book>.Sort.Ascending("Title").Descending("Price");
            var docs = collection.Find(filter).Sort(sort).ToList();
            foreach (var book in docs)
            {
                Console.WriteLine(book.Title + " By "+ book.Authors[0].Name);
            }

City of Glass By Cassandra Clare
Gone With Wind By Margaret Mitchell
The Help By Kathryn Stockett
The Lost Symbol By Dan Brown
The Lost Symbol By Dan Brown
White Fang By Jack London

 Cash.Models.ApplicationDbContext db = new Models.ApplicationDbContext();
                var listOfRows =db.Users.Join(
                    
                    db.CheckOuts,u=>u.Id,c=>c.ApplicationUserID,
                    (u,c) => new {u.FName,u.Lname,u.NationalCode,c.Creditor,c.Debtor,c.Decsription}
                    ).Where(x => x.Creditor != 0).ToList();


                dataSource.AnonymousTypeList(listOfRows);

  columns.AddColumn(column =>
                {
                    column.PropertyName<CheckOut>(x => x.Users.FName);

public interface IHasRowIntegrity
{
    string Hash { get; set; }
}

internal sealed class RowIntegrityHook : PostActionHook<IHasRowIntegrity>
{
    public override string Name => HookNames.RowIntegrity;
    public override int Order => int.MaxValue;
    public override EntityState HookState => EntityState.Unchanged;

    protected override void Hook(IHasRowIntegrity entity, HookEntityMetadata metadata, IUnitOfWork uow)
    {
        metadata.Entry.Property(EFCore.Hash).CurrentValue = uow.EntityHash(entity);
    }
}

//DbContextCore : IUnitOfWork

public string EntityHash<TEntity>(TEntity entity) where TEntity : class
{
    var row = Entry(entity).ToDictionary(p => p.Metadata.Name != EFCore.Hash &&
                                              !p.Metadata.ValueGenerated.HasFlag(ValueGenerated.OnUpdate) &&
                                              !p.Metadata.IsShadowProperty());
    return EntityHash<TEntity>(row);
}

protected virtual string EntityHash<TEntity>(Dictionary<string, object> row) where TEntity : class
{
    var json = JsonConvert.SerializeObject(row, Formatting.Indented);
    using (var hashAlgorithm = SHA256.Create())
    {
        var byteValue = Encoding.UTF8.GetBytes(json);
        var byteHash = hashAlgorithm.ComputeHash(byteValue);
        return Convert.ToBase64String(byteHash);
    }
}

services.AddEFCore<ProjectDbContext>()
    .WithTrackingHook<long>()
    .WithDeletedEntityHook()
    .WithRowLevelSecurityHook<long>()
    .WithRowIntegrityHook()
    .WithNumberingHook(options =>
    {
        options.NumberedEntityMap[typeof(Task)] = new NumberedEntityOption
        {
            Prefix = "Task",
            FieldNames = new[] {nameof(Task.BranchId)}
        };
    });

    public interface IMultiple {
        string GetName ();
    }

    public class ImplementationOne : IMultiple {
        public string GetName () {
            return "Abolfazl Roshanzamir";
        }
    }

    public class ImplementationTwo : IMultiple {
        public string GetName () {
            return "َAndy Madadian";
        }
    }

private readonly Func<string, IMultiple> _serviceAccessor;

public HomeController (Func<string, IMultiple> serviceAccessor) {
     this._serviceAccessor = serviceAccessor;
}
public IActionResult Index () {
    var implementOne = this._serviceAccessor ("A").GetName (); // Abolfazl Roshanzamir 
    var implementTwo = this._serviceAccessor ("B").GetName (); // Andy Madadian 
    return View ();
}

using System.Collections;

namespace TestModel
{
   public class DynamicEntity
   {
       public virtual int Id { get; set; }
       public virtual IDictionary Attributes { set; get; }
   }
}

using FluentNHibernate.Automapping;
using FluentNHibernate.Automapping.Alterations;

namespace TestModel
{
   public class DynamicEntityMapping : IAutoMappingOverride<DynamicEntity>
   {
       public void Override(AutoMapping<DynamicEntity> mapping)
       {
           mapping.Table("tblDynamicEntity");
           mapping.Id(x => x.Id);
           mapping.IgnoreProperty(x => x.Attributes);
           mapping.DynamicComponent(x => x.Attributes,
                    c =>
                    {                        
                        c.Map(x => (string)x["field1"]);
                        c.Map(x => (string)x["field2"]).Length(300);
                        c.Map(x => (int)x["field3"]);
                        c.Map(x => (double)x["field4"]);
                    });
       }
   }
}

   drop table tblDynamicEntity

   create table tblDynamicEntity (
       Id INT IDENTITY NOT NULL,
      field1 NVARCHAR(255) null,
      field2 NVARCHAR(300) null,
      field3 INT null,
      field4 FLOAT null,
      primary key (Id)
   )

//insert
object savedId = 0;
using (var session = sessionFactory.OpenSession())
{
    using (var tx = session.BeginTransaction())
    {
        var obj = new DynamicEntity();
        obj.Attributes = new Hashtable();
        obj.Attributes["field1"] = "test1";
        obj.Attributes["field2"] = "test2";
        obj.Attributes["field3"] = 1;
        obj.Attributes["field4"] = 1.1;

        savedId = session.Save(obj);
        tx.Commit();
      }
}

INSERT
   INTO
       tblDynamicEntity
       (field1, field2, field3, field4)
   VALUES
       (@p0, @p1, @p2, @p3);
   @p0 = 'test1' [Type: String (0)], @p1 = 'test2' [Type: String (0)], @p2 = 1
[Type: Int32 (0)], @p3 = 1.1 [Type: Double (0)]

//query
using (var session = sessionFactory.OpenSession())
{
     using (var tx = session.BeginTransaction())
     {
         //using HQL
            var list = session
                          .CreateQuery("from DynamicEntity d where d.Attributes.field1=:p0")
                           .SetString("p0", "test1")
                           .List<DynamicEntity>();

              if (list != null && list.Any())
              {
                   Console.WriteLine(list[0].Attributes["field2"]);
              }
              tx.Commit();
       }
}

    select
       dynamicent0_.Id as Id1_,
       dynamicent0_.field1 as field2_1_,
       dynamicent0_.field2 as field3_1_,
       dynamicent0_.field3 as field4_1_,
       dynamicent0_.field4 as field5_1_
   from
       tblDynamicEntity dynamicent0_
   where
       dynamicent0_.field1=@p0;
   @p0 = 'test1' [Type: String (0)]

//update
using (var session = sessionFactory.OpenSession())
{
     using (var tx = session.BeginTransaction())
     {
           var entity = session.Get<DynamicEntity>(savedId);
           if (entity != null)
           {
                entity.Attributes["field2"] = "new-val";
                tx.Commit(); // Persist modification
            }
       }
}

//delete
using (var session = sessionFactory.OpenSession())
{
    using (var tx = session.BeginTransaction())
    {
         var entity = session.Get<DynamicEntity>(savedId);
         if (entity != null)
         {
              session.Delete(entity);
              tx.Commit();
          }
     }
}

static void Profile(string description, int iterations, Action func) {
    // clean up
    GC.Collect();
    GC.WaitForPendingFinalizers();
    GC.Collect();

    // warm up 
    func();

    var watch = Stopwatch.StartNew();
    for (int i = 0; i < iterations; i++) {
        func();
    }
    watch.Stop();
    Console.Write(description);
    Console.WriteLine(" Time Elapsed {0} ms", watch.ElapsedMilliseconds);
}

Profile("a descriptions", how_many_iterations_to_run, () =>
{
   // ... code being profiled
});

var iterations = 10000000;
var testString = ".NET Tips is awesme!";
do
{
  var sb1 = new StringBuilder(testString);
  var sb2 = new StringBuilder(testString) { Capacity = testString.Length * iterations };
  try
  {
    Profiler.Profile("StringBuilder Profiler", iterations, () => sb1.Append(testString));
    Profiler.Profile("StringBuilder Capacity Profiler", iterations, () => sb2.Append(testString));
  }
  catch (Exception ex)
  {
    Console.WriteLine(ex.Message);
  }
  finally
  {
    Console.WriteLine("----------------------------------------------------------------");
    sb1.Clear();
    sb2.Clear();
  }
} while (Console.ReadKey(true).Key == ConsoleKey.C); // C = continue