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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.