SqlConnection namespace not found

Question

I'm building up a website using C#, whenever I try this

SqlConnection con = new SqlConnection ();

I get the error that SqlConnection namespace isn't found, but when I do this

System.Data.SqlClient.SqlConnection con;

it works.

Tried to add reference to System.Data.SqlClient, but couldn't find it the references lists even though System.Data is added assembly in the web.config file.

Andrey Korneyev · Accepted Answer · 2016-02-20 13:52:40Z

6

First: Ensure you're referencing System.Data not System.Data.SqlClient

Then add

using System.Data.SqlClient;

To your namespaces

edited Feb 20, 2016 at 13:52

Andrey Korneyev

26.9k16 gold badges73 silver badges72 bronze badges

answered Feb 20, 2016 at 13:51

Aydin

15.4k4 gold badges35 silver badges42 bronze badges

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

6 Comments

Aydin Over a year ago

@user2962142 Download ReSharper and things like these you won't even notice.

user2962142 Over a year ago

ops, i got an error, where im supposed to to add the using statement in the webpage ? i mean like inside the code blocks ? since im building a .net webpage

Aydin Over a year ago

You use it in your c# file, what are you developing the web page in? MVC? Also can you paste the error please

user2962142 Over a year ago

No ordinary ASP.NET Razor webpages with the extension .cshtml, if i do "@using System.Data.sqlclient;" i get error saying "} expected".

Aydin Over a year ago

Yeah that error is unrelated... Post a new question for it... include the lines of code that is causing you the issue in your new post too... :)

|

yaakov · Accepted Answer · 2016-02-20 13:54:18Z

1

As the MSDN Documentation states, SqlConnection exists in the System.Data.SqlClient namespace, inside the System.Data assembly.

A class's namespace and assembly name do not always match.

Since System.Data.SqlClient.SqlConnection works for you, you must already have a reference to System.Data. To fix the error, add a using statement for System.Data.SqlClient to the top of your file.

If you're using Visual Studio, you can right-click on SqlConnection and let Visual Studio find the correct namespace and add a using for you. This works for any class where you already have a reference to the assembly that contains it.

answered Feb 20, 2016 at 13:54

yaakov

5,9191 gold badge40 silver badges48 bronze badges

1 Comment

Kiquenet Over a year ago

I use "Visual Studio Code", dotnet add package System.Data.SqlClient and dotnet add package System.Data, but not found System.Data.SqlClient.SqlConnection

Fatemeh Mirarab · Accepted Answer · 2022-05-17 09:01:27Z

1

if you have this error in .net core , you shoud install System.Data.SqlClient Nuget package

answered May 17, 2022 at 9:01

Fatemeh Mirarab

111 bronze badge

Collectives™ on Stack Overflow

SqlConnection namespace not found

3 Answers 3

6 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related