how to fix "Failed to load microsoft.date.sqlclient version = 5.0.0.0 file or assembly..."

Question

I tried to recreate projects, installed the access engine, added microsoft.data.sqlclient through nuGet, installed various database extensions, watched a lot on the Internet, nothing helped. I need to add an access database. What should I do?

Answer 1

As Olaf indicated, you are targeting the wrong package; the target must be as shown below for a .NET Core project.

Also,

• Consider upgrading your .mdb database to a .accdb database.
• Keep away from TableAdaper; look at EF Core Jet provider or Dapper

In your project file

<ItemGroup>
   <PackageReference Include="System.Data.OleDb" Version="8.0.0" />
</ItemGroup>

Answer 2

microsoft.data.sqlclient

That data provider/namespace is to connect & work with MS SQL Server.

For MS Access database use System.Data.OleDb Namespace instead.