title: Using EF Core Code First with no foreign keys
body: <p>I am trying to design an application using EF Core 2.1, using code-first approach but I do not want Foreign Keys in my database. I find FKs a real pain to work with, especially when trying to run <code>dotnet ef database drop</code>. I get errors running this command because I have foreign keys in my database.</p>
  
  <p>I would like to just not worry about foreign keys and just make tables with <code>Id</code> properties available for related items. I will go and grab the related item from the database if/when I need that related information.</p>
  
  <pre><code>   public class Employer : BaseEntity
      {
          public string Name { get; set; }
          public string Description { get; set; }
          public ICollection&lt;Employee&gt; Employees { get; set; }
          public ICollection&lt;Client&gt; Clients { get; set; }
      }
  
  public class Employee : BaseEntity
  {
      public string FirstName { get; set; }
      public string LastName { get; set; }
      public EmployeeType EmployeeType { get; set; }
      public Guid EmployerId { get; set; }
      public Employer Employer { get; set; }
  }
  public class Client : BaseEntity
      {
          public string Name { get; set; }
          public int EmployerId { get; set; }
          public Employer Employer { get; set; }
  
      }
  </code></pre>