Developer technologies | .NET | Other
Microsoft Technologies based on the .NET software framework. Miscellaneous topics that do not fit into specific categories.
When adding DataSet in ASP.NET Framework 4.7.2 project in Visual Studio 2022 it automatically adds NuGet Package for Microsoft.Data.SQLClient after updating the version from 17.4.3
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 56.00000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kalsofte
5
Reputation points
Whenever we add a new DataSet and Table Adapter in ASP.NET Web Site (Framework 4.7.2) in Visual Studio 2022, it automatically adds NuGet Package for Microsoft.Data.SQLClient. It was not happening in the version 17.4.3 and previous versions of VS2022. After updating to the latest version of VS 2022 probably from 17.5.x the issue started. We want to stick to System.Data.SQLClient and do not want this automatic addition of Microsoft.Data.SQLClient which results in inclusion of few hundreds of files under packages. We are forced to use VS2019 for just adding datasets to our ASP.NET Web Site.
Developer technologies | .NET | Other
Developer technologies | Visual Studio | Other
Developer technologies | Visual Studio | Other
A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.
Developer technologies | ASP.NET | Other
Developer technologies | ASP.NET | Other
A set of technologies in .NET for building web applications and web services. Miscellaneous topics that do not fit into specific categories.
{count} vote
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 36%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELH%3C/text%3E%3C/svg%3E)
Lan Huang-MSFT 30,206 Reputation points Microsoft External Staff2023-06-08T06:52:38.74+00:00 Hi @Kalsofte,
Sorry, after I updated Visual Studio, I didn't find that NuGet Package will be added automatically.
You can check package settings via Tools > Options > NuGet Package Manager > General.
The following link is Restore packages in Visual Studio, you can set the opposite operation to see if it can be prevented.
If it still doesn't work, I think you can manually uninstall Microsoft.Data.SQLClient, and then download System.Data.SQLClient.
Install and manage packages in Visual Studio using the NuGet Package Manager
-
Lan Huang-MSFT 30,206 Reputation points Microsoft External Staff
2023-06-13T08:26:34.5033333+00:00 Deleted
-
Kalsofte 5 Reputation points
2023-06-15T11:24:03.4533333+00:00 Sorry for the delay in communicating the status of the issue. The issue persists whenever I add a new DataSet and add TableAdapter with existing stored procedure for Select operation. The WEB.CONFIG of my ASP.NET WebSite Project have the connectionstring with the provider System.Data.SQLClient. It is really painful to remove the auto-added packages and the files in the Bin folder flooded by Microsoft.Data.SQLClient provider which is not required for my .NET Framework 4.7.2 WebSite. If I remove the connectionstring in the WEB.CONFIG and choose new connection when adding the new DataSet, and choose the provider "Öther" and select .NET Framework provider for SQL Server and save the connectionstring with the same name as before, everything will work fine without any issues. The wizard will not add Microsoft.Data.SQLClient but it will specify the System.Data.SQLClient in the WEB.CONFIG and in the .XSD file too. This cannot be a workaround to stick to the System.Data.SQLClient and need better solution from Microsoft. Why is it forces to use Microsoft.Data.SQLClient for a .NET Framework project?
-
Kalsofte 5 Reputation points
2023-06-15T11:26:56.9766667+00:00 -
Lan Huang-MSFT 30,206 Reputation points Microsoft External Staff
2023-06-16T06:44:39.6733333+00:00 Hi @Kalsofte,
I reproduced your problem, unfortunately the Microsoft documentation doesn't provide instructions, now Visual Studio 2022 seems to use Microsoft.Data.SqlClient by default when you add a Table Adapter or DataSet. Microsoft has decided to discontinue the development of System.Data.SqlClient to focus on Microsoft.Data.SqlClient instead.
I think you can go to the visual studio forum for help, which can help you solve the problem better.
Sign in to comment
Sign in to answer