title: Table Splitting in SQL and represent in code first C#
body: <p>I have 2 tablesin SQL , rather it should have been 1 table but I split into 2 tables and represented in POCO as below</p>
  
  <pre><code>Public class Order                    
  {
      [Key] 
      public string OrderID {get;set;}
      public string OrderName {get;set;}
  }
  
  Public class OrderDetail                    
  {
      [Key] 
      public string OrderDetailID {get;set;}
      public string OrderQRCode {get;set;}
  
      [ForeignKey] 
      public string OrderID {get;set;}
  }
  </code></pre>
  
  <p>its one to one relation, How do I represent this in code first approach ? Getting "Multiplicity is not valid in Role" issue ? Life would have been easier with one table and 2 column names OrderName,OrderQRCode but cause of business reasons had to split into 2 tables</p>