4,103 questions
net 6 no longer includes System.Data.SqlClient as Microsoft.Data.SqlClient is the recommend replacement. you must use a nuget package to induce the old or new package.
SqlConnection and SqlDataAdapter not found in vb.net 6.0
![](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(99.2, 34%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Anthony White
21
Reputation points
I am trying to write a simple application to access an SQL database, but cannot reference SqlConnection or SqlDataServer. I've added
System.Data
System.Data.SqlClient
System.Data.OleDb
to the project.
Once again, this is using vb.net 6.0
Developer technologies .NET Other
Developer technologies VB
2,892 questions
SQL Server Other
14,494 questions
2 answers
Sort by: Most helpful
-
![](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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator2022-10-31T22:52:53.837+00:00 -
Anthony White 21 Reputation points
2022-11-01T10:44:06.29+00:00 I'm still not sure which package to install - Microsoft.Data.SqlClient doesn't seem to be an available package.
The relevant packages are:
Microsoft.NETCore.App
Microsoft.NETCor.TargetsWhile I am not new to VB, I haven't used it in many years.
-
Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator
2022-11-01T18:42:13.013+00:00 if its a new project you should use Microsoft.Data.SqlClient:
https://www.nuget.org/packages/Microsoft.Data.SqlClient/5.0.1
if you want to use the old library:
Sign in to comment -
-
Anthony White 21 Reputation points
2022-11-04T22:04:11.137+00:00 Thanks for the help.
I think I am going to just switch to C# for my .NET endeavors.
I am an old C++ hack. The C# examples work (I've been having a LOT of problems getting the VB examples to work with .NET 6 for what should be simple stuff), and C# just make more sense to me in terms of styling.
This may be going off topic for this question, but anyone feel free to tell me that I am wrong, and stick with VB...
-
Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator
2022-11-10T18:07:31.72+00:00 the .net core runtime, is now tightly coupled to C# and they are released in sync. vb.net is on its own release and feature cycle. thus some runtime features it may never support, or be behind, BB.net is no a mature product, and the focus is to let it run on the current runtime.
so, if you want the latest .net features, you should use C#, if you don't like changes and want more stable environment, then VB is an option.
Sign in to comment -