Is LINQ to SQL concept is compatible in SQL Server 2016 or not?

Hi All,

One of my application is developed on visual studio 2008. In it some classes uses LINQ to SQL (.dbml files) and some are using ADO.Net logic.

Till now my application is running fine without any problems by using SQL Server 2012. Recently our client suggested to migrate the SQL Server 2012 to 2016.

By using SQL Server 2016 connection, all ADO.Net classes are running fine. But when I tried to work with LINQ to SQL (.dbml files) and I am getting "This Server Version is not Supported. Only Servers up to Microsoft SQL Server 2005 are Supported".

Is LINQ to SQL concept is compatible in SQL Server 2016 or not? Please help me how to fix this issue.
s sureshAsked:
Who is Participating?
 
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
LINQ to  SQL is definitely compatible. Problem is the version of Visual Studio and the .NET framework - it's too old! (In fact, VS2008 doesn't even work with SQL 2012 without SP1). You can try upgrading to the latest service pack of VS2008, however I doubt if it will resolve your issue.

You should also consider upgrading your solution to a newer Visual Studio version to avoid compatibility issues as this one.
1
 
Pawan KumarDatabase ExpertCommented:
>>LINQ to SQL concept is compatible in SQL Server 2016
Yes they are. This issue is only with the Visual Studio 2008 version not with the higher Visual studio versions.
Please consider upgrading the higher versions of Visual Studio. I know it is a pain as your may have something running in the production but it is one time activity and somewhere down the line we have to upgrade.
0
 
Pawan KumarDatabase ExpertCommented:
Question abandoned
Provided solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.