inserting data into access database using .net core

Question

I am trying to insert data to Access 365 in .net core API. Below is what I did to insert the data, but I am getting an error saying that :

The type or namespace name 'OleDbConnection' does not exist in the namespace 'System.Data.OleDb' (are you missing an assembly reference?)

I added the assembly reference to :

    using System.Data;
    using System.Data.Odbc;
    using System.Data.OleDb

Below is my partial C# code:

  public void PrimeAccessRules()
        {
            List<RecLoad> recList = new List<RecLoad>();
            recList = getPrimeData();
            System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
            conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;" +
        @"Data source= C:\Users\test\recload.accdb";

            try
            {
                conn.Open();
            }
        }

The error is coming right on this line:

System.Data.OleDb.**OleDbConnection**

saying that OleDbConnection does not exists

Any help will be highly apprecaited.

No, I didnt. I just added it and the error is gone. I thought, by adding System.Data.oledb is enough Thanks for the help. error is gone now. — Anjali
– Anjali, Commented Apr 4, 2020 at 22:20

madreflection · Accepted Answer · 2020-04-04 22:53:35Z

1

The types in the System.Data.OleDb namespace are part of the System.Data assembly in .NET Framework, but they're not included in .NET Core or .NET Standard. Since you're targetting one of the latter two (.NET Core), you'll need to add the System.Data.OleDb package to your project.

edited Apr 4, 2020 at 22:53

answered Apr 4, 2020 at 22:40

madreflection

5,0273 gold badges26 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

inserting data into access database using .net core

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related