title: How do I make two tables in a 1 to many relationship look like 1 table?
body: <p>I have a table <code>Employer</code> and table <code>EmployerParam</code>. Having these two in a 1 to many relationship was a slight misjudgement in the DB design. Nearly every Employer has the same ten unique name-value pairs in the <code>EmployerParam</code> table, so every row in that table for one employer should actually have been a column on the <code>Employer</code> table. I need to create a facade that, for one employer, makes both tables seem like one table.</p>
  
  <p>Is there any way I can do this, using either EF5, plain old C#, T-SQL, or anything else?</p>