Error with SQL Server database in Visual Studio after using LINQPad
I have an SQL Server database which is being used for a MVC 4 project in VS 2010. I'm using LINQPad to run queries against my database. When I open LINQPad, I can connect to my .mdf database file and run queries as expected. When I close LINQPad, open up VS and try to view my database in server explorer the following error is shown:
"The database 'C:..... .MDF' cannot be opened because it is version 706. This server supports version 655 and earlier. A downgrade path is not supported. Could not open new database 'C:..... .MDF'. CREATE DATABASE is aborted. An attempt to attach an auto-named database file for 'C:..... .MDF' failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
I can drop the database and run the Seed() method via an Update-Database command from package manager as a workaround to the error, but it's a bit of a hassle to have to do it every time I connect to the database via LINQPad.