I've recently "inherited" the maintenance and support of (quite old) project that stores and manipulates data in MS SQL databases using Linq to SQL. I have little to no experience in this field and recently a customer informed us that their data center is planning update of DB drivers AND disabling of SQL Native Client.

I've spent quite some time trying to understand the relations/version compatibility between ADO providers, DB drivers and Linq to SQL and honestly I feel like I'm missing the big picture. Connection string used to initiate DataContext instance is an OLEDB connection string but my understanding is too shallow to rule out usage of SQL Native Client.

If someone could point me in the right direction, that would be really great.

CodePudding user response：

Linq to SQL uses the .NET Framework's System.Data.SqlClient. This is separate driver from SQL Native Client's ODBC and OleDB drivers, and is updated as part of Windows updates.