CODEWITHSUNDEEP
c#.netnamespacesoledb
Reshma
Reshma

Reputation: 904

OleDbConnection not found while using System.data namespace in code

In my code, I am using OleDbConnection. When I refer to System.Data, it gives me the error that OleDbConnection is not found. But when I refer to System.Data.OleDb namespace then it runs fine. Why is this error occurring? I checked for the reference via add reference path for System.Data and it exist.

Find the below code for better clearance:

using System.Data;

public partial class Home : System.Web.UI.Page
{
  OleDbConnection oledbconn;
  protected void Page_Load(object sender, EventArgs e)
  {

  }
}

In above code, OleDbConnection oledbconn;---This line no 4 gives error that

Type or namespace OleDbConnection cannot be found

And now consider the following code,

using System.Data.OleDb;

public partial class Home : System.Web.UI.Page
{
    OleDbConnection oledbconn;
    protected void Page_Load(object sender, EventArgs e)
    {

    }
}

Here the code works fine,

I know that adding OleDb to System.Data will resolve my issue but I want to know why does it gives error in first place even if I have referred to System.Data namespace,

According to my knowing, when I refer to System.Data, it indirectly refer to all his child elements like OleDb, SqlClient and all..isn't it?

Upvotes: 2

Views: 29066

Answers (1)

NPras
NPras

Reputation: 4115

System.Data is the assembly you reference to in your project. It contains many namespaces within it, one of which is System.Data.OleDb.

If you right-click on the System.Data reference > View in Object Browser, you can browse for everything within the assembly. You can see in there that the OleDbConnection class is contained within the System.Data.OleDb namespace.

If you're unsure about where a class lives, always search in MSDN. This page would immediately tell you that OleDbConnection lives in:

Namespace: System.Data.OleDb

Assembly: System.Data (in System.Data.dll)

Upvotes: 4

Related Questions