title: having 2 one to one relations EF
body: <p>I have been doing some research into the fluent API to be able to make this but i am not sure if that is the way to go, from what i understand the <code>OnModelCreate</code> will recreate a DB but what i actually need is a way to relate my tables for my entity, i have a DB with this 2 tables</p>
  
  <pre><code>dbo.Fleets 
  OwnerId   (PK,uniqueidentifier,not null) 
  ownerName (nvarchar(255),not null)
  
  
  dbo.UserAccount
  UserID        (PK,uniqueidentifier,not null)
  UserName      (nchar(20), null)
  SelectedFleet (FK,uniqueidentifier,null)
  PrimaryFleet  (FK,UniqueIdentifier,null)
  </code></pre>
  
  <p>The foreign keys are for <code>Fleets.OwnerId</code>, both of them, so inside my application i want to be able to get the fleet for my Primary and <code>SelectedFleet</code> with <code>EF</code>.</p>
  
  <p>so if i run <code>var v = dc.UserAccounts.Where(a =&gt; a.UserName == model.UserName).Include(d =&gt; d.Fleet).SingleOrDefault();</code> I'll be getting my complete results</p>