using System;
using System.Collections.Generic;

namespace ConsoleApplication1.Models;

public partial class Customer
{
    public string Id { get; set; }

    public string Name { get; set; }

    public string Email { get; set; }

    public List<string> Tags { get; set; } = new List<string>();

    public Address Address { get; set; }

    public List<Phone> Phones { get; set; } = new List<Phone>();
}

using System;
using System.Collections.Generic;

namespace ConsoleApplication1.Models;

public partial class Address
{
    public string City { get; set; }

    public string Street { get; set; }
}

using System;
using System.Collections.Generic;

namespace ConsoleApplication1.Models;

public partial class Phone
{
    public string Kind { get; set; }

    public string Number { get; set; }
}

using System;
using System.Collections.Generic;

namespace ConsoleApplication1.Models;

public partial class Order
{
    public string Id { get; set; }

    public string CustomerId { get; set; }

    public DateTime? OrderDate { get; set; }

    public string Total { get; set; }

    public int? Quantity { get; set; }

    public bool? Paid { get; set; }
}

using System;
using System.Collections.Generic;
using Microsoft.EntityFrameworkCore;

namespace ConsoleApplication1.Models;

public partial class SampleContext : DbContext
{
    public SampleContext()
    {
    }

    public SampleContext(DbContextOptions<SampleContext> options)
        : base(options)
    {
    }

    public virtual DbSet<Customer> Customers { get; set; }

    public virtual DbSet<Order> Orders { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
#warning To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see https://go.microsoft.com/fwlink/?LinkId=723263.
        => optionsBuilder.UseMongoDB("Host=localhost;Database=sample;User Id=user;Password=pwd;License Key=***");

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Customer>(entity =>
        {
            entity.ToTable("customers");

            entity.Property(e => e.Id)
                .HasColumnType("oid")
                .HasColumnName("_id");
            entity.Property(e => e.Email)
                .HasColumnType("varchar")
                .HasColumnName("email");
            entity.Property(e => e.Name)
                .HasColumnType("varchar")
                .HasColumnName("name");

            entity.Property(e => e.Tags).HasColumnName("tags");

            entity.OwnsOne(e => e.Address, b =>
            {
                b.ToJson("address");
                b.Property(p => p.City).HasJsonPropertyName("city");
                b.Property(p => p.Street).HasJsonPropertyName("street");
            });

            entity.OwnsMany(e => e.Phones, b =>
            {
                b.ToJson("phones");
                b.Property(p => p.Kind).HasJsonPropertyName("kind");
                b.Property(p => p.Number).HasJsonPropertyName("number");
            });
        });

        modelBuilder.Entity<Order>(entity =>
        {
            entity.ToTable("orders");

            entity.Property(e => e.Id)
                .HasColumnType("oid")
                .HasColumnName("_id");
            entity.Property(e => e.CustomerId)
                .HasColumnType("oid")
                .HasColumnName("customerId");
            entity.Property(e => e.OrderDate).HasColumnName("orderDate");
            entity.Property(e => e.Paid).HasColumnName("paid");
            entity.Property(e => e.Quantity).HasColumnName("quantity");
            entity.Property(e => e.Total)
                .HasColumnType("decimal128")
                .HasColumnName("total");
        });

        OnModelCreatingPartial(modelBuilder);
    }

    partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
}

using ConsoleApplication1.Models;

using (var db = new SampleContext())
{
    // Creating a new customer and saving it to the database
    var customer = new Customer
    {
        Name = "Ann Lee",
        Email = "[email protected]",
        Address = new Address { City = "Rome", Street = "Via Veneto 5" },
        Phones = new List<Phone> { new Phone { Kind = "mobile", Number = "+39 347 1112233" } },
        Tags = new List<string> { "vip" }
    };
    db.Customers.Add(customer);
    var count = db.SaveChanges();
    Console.WriteLine("{0} records saved to database, new _id: {1}", count, customer.Id);

    // Retrieving and displaying data
    Console.WriteLine();
    Console.WriteLine("Customers from Rome:");
    foreach (var c in db.Customers.Where(c => c.Address.City == "Rome").OrderBy(c => c.Name))
        Console.WriteLine("{0} | {1} | {2}", c.Name, c.Address.Street, string.Join(", ", c.Tags));

    Console.WriteLine();
    Console.WriteLine("VIP customers with a mobile phone:");
    foreach (var c in db.Customers.Where(c => c.Tags.Contains("vip") && c.Phones.Any(p => p.Kind == "mobile")))
        Console.WriteLine("{0} | {1}", c.Name, c.Phones.First(p => p.Kind == "mobile").Number);

    Console.WriteLine();
    Console.WriteLine("Paid orders:");
    var paid = from o in db.Orders
               join c in db.Customers on o.CustomerId equals c.Id
               where o.Paid == true
               orderby o.OrderDate
               select new { c.Name, o.OrderDate, o.Total };
    foreach (var o in paid)
        Console.WriteLine("{0:yyyy-MM-dd} | {1} | {2}", o.OrderDate, o.Name, o.Total);
}