SQLConnection not part of System.Data.SqlClient in VS 2019?

Question

I am using Visual Studio 2019, C#, and added

Using System.Data.SqlClient;

When I use the following code:

SqlConnection cnn;

I get the error:

Severity Code Description Project File Line Suppression State Error CS1069 The type name 'SqlConnection' could not be found in the namespace 'System.Data.SqlClient'. This type has been forwarded to assembly 'System.Data.SqlClient, Version=4.6.1.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' Consider adding a reference to that assembly

Is the SqlConnection type no longer part of the Data SQLClient in Visual Studio 2019?

Did you choose .NET Core instead of .NET Framework? Maybe you could use the new version: Introducing the new Microsoft.Data.SqlClient. — Andrew Morton
– Andrew Morton, Commented Jul 7, 2020 at 12:40
Or if you want to use System.Data.SqlClient, you can add it through the NuGet Package Manager. — Andrew Morton
– Andrew Morton, Commented Jul 7, 2020 at 13:44

Marc Gravell · Accepted Answer · 2020-07-09 08:52:33Z

9

This all comes down to what packages you have installed; SqlClient is no longer part of System.Data.Common, so to use System.Data.SqlClient you would need a package reference to:

<PackageReference Include="System.Data.SqlClient" Version="4.8.1" />

However, it is recommended (when possible) to prefer the new

<PackageReference Include="Microsoft.Data.SqlClient" Version="2.0.0" />

instead when possible; this is the replacement, but requires a different namespace (Microsoft.Data.SqlClient instead of System.Data.SqlClient)

answered Jul 9, 2020 at 8:52

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tsahi Asher · Accepted Answer · 2023-02-01 17:08:09Z

9

If you in .net core 3.x, please use NuGet to get Microsoft.Data.SqlClient. Then call "using Microsoft.Data.SqlClient;".

Step 1:

Step 2:

edited Feb 1, 2023 at 17:08

Tsahi Asher

1,83417 silver badges30 bronze badges

answered Jul 9, 2020 at 7:15

Tery123

1257 bronze badges

Comments

Abed ElHameed Jaber · Accepted Answer · 2022-06-15 08:10:21Z

1

you should use: using Microsoft.Data.SqlClient;

not: using System.Data.SqlClient;

answered Jun 15, 2022 at 8:10

Abed ElHameed Jaber

331 silver badge7 bronze badges

Collectives™ on Stack Overflow

SQLConnection not part of System.Data.SqlClient in VS 2019?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related