'No Entity Framework provider found' for EF 6 and SQLite 1.0.96.0 'No Entity Framework provider found' for EF 6 and SQLite 1.0.96.0 sqlite sqlite

'No Entity Framework provider found' for EF 6 and SQLite 1.0.96.0


I solved same error with just add a single line in App.config

<provider invariantName="System.Data.SQLite" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6"/>

PS: Add provider to <configuration> > <entityFramework> > <providers>


Here is a working app.config

<?xml version="1.0" encoding="utf-8"?><configuration>  <configSections>    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />  </configSections>  <startup>    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2" />  </startup>  <entityFramework>    <providers>      <provider invariantName="System.Data.SQLite" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6"/>    </providers>  </entityFramework>  <connectionStrings>    <!-- use AppDomain.SetData to set the DataDirectory -->    <add name="MapDbConnectionStr" connectionString="Data Source=|DataDirectory|MapDb.sqlite" providerName="System.Data.SQLite" />  </connectionStrings>  <system.data>    <DbProviderFactories>      <remove invariant="System.Data.SQLite.EF6" />      <add name="SQLite Data Provider" invariant="System.Data.SQLite" description="Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />    </DbProviderFactories>  </system.data></configuration>


I finally got it too work

I'm using :EF 6.1.3http://www.microsoft.com/en-us/download/details.aspx?id=40762and System.Data.SQLite 1.0.96.0sqlite-netFx451-setup-bundle-x86-2013-1.0.96.0.exe

I followed the description written in:Database first create entity framework 6.1.1 model using system.data.sqlite 1.0.93(in this description a nuget package of entity framwork is installed -i did it too)

For the app.config file i used these fixes:https://stackoverflow.com/a/24324212/885349(written by tomexou)

Finally SQLite Connector wasn't shown in the ADO.Net Entity Data Model Mapper

The missing link was the \bin folder.I had to set the "Copy Local" = true setting for following dlls:

  • SQLite.Designer
  • System.Data.SQLite
  • System.Data.SQLite.EF6
  • System.Data.SQLite.Linq

Only for completeness - added through Nuget and also in \bin folder

  • EntityFramework
  • EntityFramework.SqlServer

And the SQLite Connection was shown...