Following your advices here are the steps that worked for me:
For Visual Studio
2012:
Tutorial you referred to
- Install System.Data.SQLite 1.0.94.0 from
This link
Select the appropriate file for target O.S. and .NET framework version.
During installation I selected all checkboxes.
It is important that the DDEXprovider version matches the version of the current SQLite EF6 NuGet package that you use in your project!
- Install Entity Framework 6.1.2 Visual Studio tools from
This Microsoft link
- Install NuGet package: System.Data.SQLite.EF6 (1.0.94.0).
EntityFramework will install automatically as a dependency for this package.
-
You must build/rebuild the solution before the SQLite provider shows in the EDM wizard.
- Verify that under Project Properties | References the SQLite dll's are set to copy locally and actually copied to the Bin folder. VS will apparently randomly set the property to False.
- In App.config add a provider in the DbProviderFactories section:
<add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".NET Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
This install worked for me as of 02/20/2015.