Clever Geek Handbook

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-1.0.94.0 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.

+3


source to share


1 answer


Make sure the system.data section looks like this:



<system.data>
 <DbProviderFactories>
    <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" />
 </DbProviderFactories>
</system.data>
+1


source






More articles:


All Articles