Skip to main content

MVC: Fix: The version of SQL Server in use does not support datatype 'datetime2'.

This message appeared today after posting a new build to our ASP.NET 4 web app:
The version of SQL Server in use does not support datatype 'datetime2'.
The DBA doesn’t use datetime2 because it’s new in SQL Server 2008 and the site runs on 2005. 
It turns out that Entity Framework 4 somehow got the idea to use  SQL Server 2008. The fix was to edit the .edmx file in an XML editor and set the ProviderManifestToken="2005"instead of 2008. (You need to rebuild.) Here’s how the line should look against SQL Server 2005:
<Schema Namespace="OfficeBookDBModel.Store"
Alias="Self" Provider="System.Data.SqlClient"
ProviderManifestToken="2005"
xmlns:store=http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator
xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
  
I’m not sure where EF got the notion to ‘upgrade’ to SQL Server 2008. Perhaps it detected something locally.  I’ve just built a new workstation and installed a CTP of  SQL Server Management Studio Basic  10.50.1352.12. It’s working with the database marked as compatibility level SQL Server 2005 (90).

Anyway, if you hit this error, let’s hope you haven’t lost time like I did!
Labels:

Comments

Post a Comment

Popular posts from this blog

ASP.NET MVC - Set custom IIdentity or IPrincipal

Here's how I do it. I decided to use IPrincipal instead of IIdentity because it means I don't have to implement both IIdentity and IPrincipal. Create the interface interface ICustomPrincipal : IPrincipal { int UserId { get ; set ; } string FirstName { get ; set ; } string LastName { get ; set ; } } CustomPrincipal public class CustomPrincipal : ICustomPrincipal { public IIdentity Identity { get ; private set ; } public bool IsInRole ( string role ) { return false ; } public CustomPrincipal ( string email ) { this . Identity = new GenericIdentity ( email ); } public int UserId { get ; set ; } public string FirstName { get ; set ; } public string LastName { get ; set ; } } CustomPrincipalSerializeModel - for serializing custom information into userdata field in FormsAuthenticationTicket object. public class CustomPrincipalSerializeMode...
8 comments
Read more

Validate credit card number with Mod 10 algorithm in C#

Introduction All you know what information contains in your NIC number. But do you know what information contains in the Credit Card Number? Following article provides brief details about what information contain in your credit card and demonstrates to how to validate credit card number using mod 10 (Luhn) algorithms with C#. Background  Card Length   Typically, credit card numbers are all numeric and the length of the credit card number is between 12 digits to 19 digits.  14, 15, 16 digits – Diners Club 15 digits – American Express 13, 16 digits – Visa 16 digits - MasterCard   For more information please refer  http://en.wikipedia.org/wiki/Bank_card_number . Hidden information  Major Industry Identifier (MII)   The first digit of the credit card number is the Major Industry Identifier (MII). It designates the category of the entry which issued the card.     1 and 2 – Airlin...
1 comment
Read more

How to Scroll to an Element with Javascript

  Overview Scrolling to a specific element or part of a webpage is mainly done to keep a user intact with the webpage for a longer period. A scroll is a function that can be used also to scroll to the beginning of a webpage from the bottom of the webpage instantly. Instant scrolling functionality is done or implemented using JavaScript. Scrolling to a particular section of a webpage adds a single-click functionality without much intervention from the user. There are different JavaScript scroll to element methods that are used to implement the functionality of scrolling to a particular element. These methods include: JavaScript  scrollIntoView  method. JavaScript  scroll  method. JavsScript  scrollTo  method. In this article, we will understand them thoroughly. Introduction Before learning about the JavaScript scroll to element, Let's learn a bit about JavaScript. JavaScript  is an object-oriented programming language used on web pages. JavaScript ...
Post a Comment
Read more