title: Entity Framework - Invalid Column Name '*_ID"
body: <p>I've narrowed this down to some issue between Code First and Database first EF, but I'm not sure how to fix it. I'll try to be as clear as I can, but I honestly am missing some of the understanding here myself.  This is Entity Framework 4.4</p>
  
  <p>I inherited a project where Entity Framework was used, but many of the actual files were deleted with no real way to go back.  I re-added EF (Database first) and replicated a T4 setup that the project was built around.  It generated code versions of all the database models and a DBContext code file.  </p>
  
  <p>If my connection string looks like a "normal" .NET connection string I get an error about an invalid column Name "ProcessState_ID" does not exist.  ProcessState_ID is not in the code base at all, it is not in the EDMX file or anything.  This appears to be some automatic EF conversion in the query.</p>
  
  <p>When I make the connection string match the Entity Framework model it works fine.</p>
  
  <p>Now in trying to match the previous code with Entity Framework I'd like to keep the "normal" .NET connection string.</p>
  
  <p>So I have two questions here:
  1. What is a good way to go from a normal connection string to an EF connection string in code?
  2. Is there another fix here that I'm not seeing to stop the invalid column name error?</p>