title: Where does the 'Name' property in a DBML come from?
body: <p>I'm using Linq-To-Sql and inside my DBML there are objects built from the database connection provided. </p>
  
  <p>If you click on an association line between two tables and view the properties on it, you will get the following:</p>
  
  <ul>
  <li>Cardinality </li>
  <li>Child Property<br>
  <ul>
  <li>Access  </li>
  <li>Inheritance Modifier   </li>
  <li><strong>Name</strong></li>
  </ul></li>
  <li>Parent Property<br>
  <ul>
  <li>Access  </li>
  <li>Inheritance Modifier</li>
  <li><strong>Name</strong></li>
  </ul></li>
  <li>Participating Properties </li>
  <li>Unique</li>
  </ul>
  
  <p>My question is, where does Linq-To-Sql get the "Name" properties from? Where is the correlation to the actual database? </p>
  
  <p>I ask this because if this table happens to be a parent to several children, Linq-To-Sql will just simply name these properties, "<em>SomeParentName</em>", "<em>SomeParentName2</em>", "<em>SomeParentName3</em>" , etc. So you'd have to go into the DBML and manually change these names to something meaningful every time you update this table.</p>
  
  <p>Any help you can provide would be appreciated. </p>
  
  <p>Part 2 of my question might be how do you guys handle these situations? </p>