SQLite 1.0.94 not showing up in EDM providers

I noticed that this is also a problem with 1.0.93, but it also applies to 1.0.94.

More specific:

  • Machine runs Windows 8.1 x64, Visual Studio 2013
  • Install sqlite-netFx451-setup-bundle-x86-2013- from SQLite official site.
  • Create a C # .NET 4.5.1 console project
  • Add NuGet SQLite x86 / x64
  • Add "ADO.NET Entity Data Model" to my project
  • Select EF Designer from Database
  • SQLite is not listed in the list of data source providers.

In contrast, the SQLite provider shows up if I add a connection in Server Explorer. However, this is not enough as I need to use Entity Framework 6.1.1.

If anyone has a solution please share it. Thank.


source to share

1 answer

Make sure the system.data section looks like this:

    <remove invariant="System.Data.SQLite" />
    <remove invariant="System.Data.SQLite.EF6" />
    <add name="SQLite Data Provider (Entity Framework 6)" invariant="System.Data.SQLite.EF6" description=".NET Framework Data Provider for SQLite (Entity Framework 6)" type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6" />




All Articles