So I am trying to connect my program to a SQLite database using entity framework 6.1.3, the same code worked on a SQL server database with Entity framework core 1.0, but it doesn't support SQLite as far as I understand.
So I switched to EF6, I downloaded and installed http://system.data.sqlite.org/downloads/22.214.171.124/sqlite-netFx46-setup-bundle-x86-2015-126.96.36.199.exe, and I connected to the database file, and EF mapped it correctly, but when I run the code I get the error:
" Exception thrown: 'System.InvalidOperationException' in EntityFramework.dll
Additional information: No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SQLite'. Make sure the provider is registered in the 'entityFramework' section of the application config file. See http://go.microsoft.com/fwlink/?LinkId=260882 for more information."
And in app.cfg, I see
Is there a way to add system.data.sqlite on its own manually? Or is this a different problem?