title: The version of SQL Server in use does not support datatype datetime2?
body: <pre><code>An error occurred while executing the command definition. See the inner exception for details. bbbbInnerException:aaaa System.ArgumentException: The version of SQL Server in use does not support datatype 'datetime2'.
  
     at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
  
     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
  
     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
  
     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
  
     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
  
     at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
  
     at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
  
     at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavioR
  </code></pre>
  
  <p>I have a website using Entity Framework.  A few months ago I added a new table, and added some columns to existing tables; everything worked fine.</p>
  
  <p>Today I updated the mapping of the EDMX so the new table and the new column can be used, and added WebMethods to my services.asmx file.  Since then I cannot run my site because I have that error that I cannot understand.  Please explain it to me if you understand, and tell me where is my mistake.</p>
  
  <p>I have not used <strong>datetime2</strong> anywhere.  There is no such datatype in my new table, nor in the columns that I added to existing tables.</p>
  
  <p>The version of SQL on my PC is SQL2008 R2, on the server i have SQL2008.  I do not have the option to upgrade the server to R2.</p>