search

ErikEJ / EFCorePowerTools

Entity Framework Core Power Tools - reverse engineering, migrations and model visualization in Visual Studio & CLI
MIT License
2.12k stars 293 forks source link

Unable to find data provider #983

Closed jgyo closed 3 years ago

jgyo commented 3 years ago

I am having a problem with EF Core Power Tools when I try to use it to reverse engineer an SQLite database in Visual Studio Community 2019, version 16.9.5. When I try to establish a connection I get an error stating, "Unable to find the requested .NET Framework Data Provider. It may not be installed."

Snag_732f1f

OTOH when I test the connection from the same Connection Properties dialog box, I see a successful connection.

Snag_734db3

I also have no trouble connecting to the database using SqlCeToolBox.

Snag_745167 Snag_746945

I have checked all of my machine.config files under C:\Windows\Microsoft.NET that I've seen mentioned in several blogs for a corrupted DbProviderFactories node, but could find nothing like the articles described. I did notice that there was no data provider given in any of the config files for Sqlite.

Steps to reproduce

Snag_7c6eeb Snag_7e7e43 Snag_80251d Snag_8345d5 Snag_83e215

Further technical details

Snag_84e359

Database engine: SQlite Visual Studio Community 2019, version 16.9.5

jgyo commented 3 years ago

I was able to fix my problem with help you provided here:

EF6-workflow-with-SQLite-DDEX-provider

I had not yet downloaded the correct "sqlite-netFx46-setup-bundle-x86-2015-1.0.xxx.0.exe (from https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki)."