EF: The database cannot be opened because it is version 782

    The full error message for this is "The database cannot be opened because it is version 782. This server supports version 706 and earlier. A downgrade path is not supported" and started appearing for me when I upgraded to Visual Studio 2015 Community. Originally I created a database file in visual studio 2013.

<add name="ProductContext" connectionString="Data Source=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\ProductContext.mdf;Initial Catalog=ProductContext;Integrated Security=True" providerName="System.Data.SqlClient" />

<add name="ProductContext" connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\ProductContext.mdf;Initial Catalog=ProductContext;Integrated Security=True" providerName="System.Data.SqlClient" />

Notes
I did not have to delete the local database files and have to start over, thankfully it was a small change.

Resource
http://sqlserverbuilds.blogspot.com/2014/01/sql-server-internal-database-versions.html



Popular posts from this blog

Nginx Best Practices Extended

Installing Windows on Acer chromebook 15 cb3-532

Entity Framework: ToListAynsc & WhereAsync