title: Unique Keys not recognized by Entity Framework
body: <p>I have two tables, <code>Reports</code> and <code>Visualizations</code>. <code>Reports</code> has a field, <code>VisualizationID</code>, which points to <code>Visualization</code>'s field of the same name via a foreign key. It also has a unique key declared on the field. <code>VisualizationID</code> is not nullable. This means the relationship has to be 0..1 to 1, because <strong>every</strong> <code>Reports</code> record must have a unique, not null <code>Visualizations</code> record associated with it.</p>
  
  <p>The Entity Framework doesn't see it this way. I'm getting the following error:</p>
  
  <p><code>Error 113: Multiplicity is not valid in Role 'Report' in relationship 'FK_Reports_Visualizations'. Because the Dependent Role properties are not the key properties, the upper bound of the multiplicity of the Dependent Role must be *.</code></p>
  
  <p>What's the problem here? How can I make the EF recognize the proper relationship multiplicity?</p>