C#

using (var dbCtx = new CustomerManagerContext())
            {
                dbCtx.Customers.Add(customer1);
                dbCtx.SaveChanges();
                 dbCtx.Customers.Add(customer2);
                dbCtx.SaveChanges();
                dbCtx.Companies.Add(company1);
                //call SaveChanges
                dbCtx.SaveChanges();
               
                 dbCtx.Orders.Add(order1);
                 dbCtx.SaveChanges();
                dbCtx.Orders.Add(order2);
                 dbCtx.SaveChanges();
                
            }

protected override void OnModelCreating(DbModelBuilder modelBuilder)
       {

           modelBuilder.Entity<Customer>().
           HasMany(c => c.Companies).
           WithMany(p => p.Customers).
           Map(
           m =>
           {
               m.MapLeftKey("CustomerId");
               m.MapRightKey("CompanyId");
               m.ToTable("CustomerCompany");
           });
           modelBuilder.Entity<Company>().HasRequired(c => c.Customers).WithMany().WillCascadeOnDelete(false);
           modelBuilder.Entity<Customer>().HasRequired(c => c.Companies).WithMany().WillCascadeOnDelete(false);
           base.OnModelCreating(modelBuilder);
       }

public class MyContext : DbContext
{
   public DbSet<Customer> Customers { get; set; }
   public DbSet<Company> Companies { get; set; }
   public DbSet<Order> Orders { get; set; }
}

public class Company
{
[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)] [Display(AutoGenerateField = false)]
public int CompanyId { get; set; }

[StringLength(50)]
public string Name { get; set; }

[StringLength(200)]
public string Address { get; set; }

[StringLength(500)]
public string Email { get; set; }

[StringLength(1000)]
public string Phone { get; set; }

[StringLength(50)]
public string City { get; set; }

public State State { get; set; }
public int StateId { get; set; }
public int Zip { get; set; }

public virtual ICollection Orders{ get; set; } // Change for M:M mapping
}

public class Customer
{
[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)] [Display(AutoGenerateField = false)]
public int CustomerId { get; set; }

[StringLength(50)]
public string FirstName { get; set; }

[StringLength(50)]
public string LastName { get; set; }

[StringLength(100)]
public string Email { get; set; }

[StringLength(1000)]
public string Address { get; set; }

[StringLength(50)]
public string City { get; set; }
public int Zip { get; set; }

//State is not a valid class for the DB. If it's a Table do this
[Display(AutoGenerateField = false), ForeignKey("State")]
public int StateId { get; set; }
public virtual State State { get; set; } 

public virtual ICollection Orders{ get; set; } // Change for M:M mapping

// Gender is not a valid field class. Just use the enum string (or int) value
public string Gender { get; set; }

public class Order
{
[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)] [Display(AutoGenerateField = false)]
public int Id { get; set; }

/*
Order-specific fields here.
*/

[Display(AutoGenerateField = false), ForeignKey("Customer")]
public int CustomerId { get; set; }
[Display(AutoGenerateField = false), ForeignKey("Company")]
public int CompanyId { get; set; }

public virtual Customer Customer { get; set; }
public virtual Company Company { get; set; }

public Order(){}

public Order(Customer customer, Company company)
{
CustomerId = customer.CustomerId;
CompanyId = company.CompanyId;
}
}

public class MyContext : DbContext
{
   public DbSet<Customer> Customers { get; set; }
   public DbSet<Company> Companies { get; set; }
   public DbSet<Order> Orders { get; set; }

   public bool UpdateOrder(Order order)
   {
      if(Orders.Any(x => x.Id == order.Id))
         this.Entry(order).State = EntityState.Modified;
      else
         Orders.Add(order);
      return this.SaveChanges() != 0;
   }
   public bool UpdateCompany(Company company)
   {
      if(Companies.Any(x => x.CompanyId == company.CompanyId))
         this.Entry(company).State = EntityState.Modified;
      else
         Companies.Add(company);
      return this.SaveChanges() != 0;
   }
   public bool UpdateCustomer(Customer customer)
   {
      if(Customers.Any(x => x.CustomerId == customer.CustomerId))
         this.Entry(customer).State = EntityState.Modified;
      else
         Customers.Add(customer);
      return this.SaveChanges() != 0;
   }
   public bool DeleteOrder(Order order)
   {
      if(Orders.Any(x => x.Id == order.Id))
      {
         Orders.Remove(order);
         return this.SaveChanges() != 0;
      }
      return false;
   }
// etc...
}

• EPPlus[^]
• ClosedXML[^]
• NPOI[^]

<pre lang="c#"> 
using sExcel = Microsoft.Office.Interop.Excel;
using Microsoft.Office.Interop.Excel;
sExcel.Application excel = new sExcel.Application();
            //Options to ommite the excel sesion
            excel.ScreenUpdating = false;
            excel.Visible = false;
            excel.DisplayAlerts = false;
            excel.AutomationSecurity = Microsoft.Office.Core.MsoAutomationSecurity.msoAutomationSecurityLow;
            Workbook wb = excel.Workbooks.Add();
            Worksheet ws = excel.Worksheets[1];
            ws.Name = "ws";