ErikEJ / SqlCeToolbox

SQLite & SQL Server Compact Toolbox extension for Visual Studio, SSMS (and stand alone)
Other
839 stars 175 forks source link

ADO.NET provider with invariant name 'System.Data.SQLite' is either not registered #661

Closed hongil14 closed 6 years ago

hongil14 commented 6 years ago

Hello,

I'm getting the following error below: An unhandled exception of type 'System.ArgumentException' occurred in EntityFramework.dll The ADO.NET provider with invariant name 'System.Data.SQLite' is either not registered in the machine or application config file, or could not be loaded. See the inner exception for details.

I'm wondering if I have missed something to set up further. Thank you.

Steps to reproduce

I have installed the followings below:

[packages.config] `<?xml version="1.0" encoding="utf-8"?>

` [App.config] `
` ### Further technical details Toolbox/Power Tools version: 4.7.534.0 Database engine: SQLite Visual Studio or SSMS version: Visual Studio 2017 15.6.3 =======copy from about info==================== Version 4.7.534.0 - 1,042,058 downloads SQL Server Compact 4.0 in GAC - No SQL Server Compact 4.0 DbProvider - No SQL Server Compact 4.0 DDEX provider - No SQL Server Compact 4.0 Simple DDEX provider - Yes SQL Server Compact 3.5 in GAC - No SQL Server Compact 3.5 DbProvider - No SQL Server Compact 3.5 DDEX provider - No Sync Framework 2.1 SqlCe 3.5 provider - No SQLite ADO.NET Provider included: 1.0.107.0 SQLite EF6 DbProvider in GAC - Yes System.Data.SQLite DDEX provider - No SQLite Simple DDEX provider - Yes
ErikEJ commented 6 years ago

What is the Inner exception?

Did you check this guide: https://github.com/ErikEJ/SqlCeToolbox/wiki/EF6-workflow-with-SQLite-DDEX-provider ?

ErikEJ commented 6 years ago

Closing as additional information not received - feel free to re-open