title: Entity Framework datetime data types mappings
body: <p>I have realized that a smalldatetime sql server data type has been mapped to a datetime in my entity project. Fine with me. When the entity is saving changes it actually uses a datetime2 data type (which currently our production database doesn't support). Now, that's a problem.</p>
  
  <p>Looking at the entity designer code i see the property is using VB's date object although the properties window displays it as a datetime. </p>
  
  <p>I would rather not change the entity code as I do not want updates from the database to overwrite my changes creating a code maintenance mess.   </p>
  
  <p>Where did the datetime2 come from? Any ideas? </p>
  
  <p>Thanks in advance for any help,
  Orry</p>