C#

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";