could not load file or assembly'Microsoft.data.sqlclient'

Question

how to solve this error

Answer 1

Visual studio 2022 has an incomplete installation... using the "Data source configuration wizard" it misses the Microsoft.Data.SQLclient (VS2022 17.10). It is a feature / component of VS2022 and not of my project... it's made to generate code so I wont have to type everything by hand. I have installed all of the SQL features in the VS setup.

The hint with the Nuget package is wrong - I cannot install it into the project then it says the project has no reference to it. So other way around..

The Wizard tells me "install missing packages" when choosing any of the .net options but it fails to do so... I expect that this is in the VS setup somewhere and not in a Nuget package that I have to add to each and every project I am creating, "other" works then ,net data provider for ODBC.

And that is "dirty" because at the very end it asks again for Microsoft.Data.SQLClient.

Going further "report feedback" gest stuck in a stupid java script error, VS2022 also cannot log in with that javascript error....

Answer 2

Please install the NuGet package:

Answer 3

Hi @Niyati Savaliya

Step 1: Install "Microsoft.data.sqlclient" on Nuget Package Manager

Step 2: Check whether the addition is successful under Reference

Step 3: Call at the beginning of the class you want to call

Best regards,
Qi You

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 4

be sure you added the nuget package and restored.