SqlConnection and SqlDataAdapter not found in vb.net 6.0

Question

SqlConnection and SqlDataAdapter not found in vb.net 6.0

Anthony White 21

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

2 answers

Your answer

Answer 1

Bruce (SqlWork.com) 77,926 Volunteer Moderator

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.

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.Targets

While I am not new to VB, I haven't used it in many years.
Bruce (SqlWork.com) 77,926 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:

https://www.nuget.org/packages/System.Data.SqlClient

Answer 2

Anthony White 21

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,926 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.

Share via

SqlConnection and SqlDataAdapter not found in vb.net 6.0

2 answers

Your answer