title: Entity Framework model-first design not won't let you edit the table mappings?
body: <p>If we've been using an Entity Framework 4 model for some time, and we eventually want to switch the underlying database to a different vendor's product (say, from SQL Server to MySQL), is it simple to adjust the table and column mappings in the entity model without needing to update any of the entity class code?</p>
  
  <p>We're trying to design code that is as database agnostic as possible, so I'd like to know in advance how much trouble we're in for if we ever switch our databases around.  Ideally, we'd like to not have to touch our applications that use our entity classes.  I can't seem to find any way in the entity designer or XML editor to adjust the underlying database column names without it giving me an error.</p>
  
  <p>(I can, however, edit the entity's property names in the designer while leaving the database column names alone, but that's the opposite of what I need.)</p>
  
  <p>Thanks!</p>