How SQLite and Entity Framework 6 combine

Question

I am trying to get done with Entity Framework 5 on SQLite (http://brice-lambson.blogspot.ru/2012/10/entity-framework-on-sqlite.html). I have installed SQLite and EF6. However I got an error :

The 'Instance' member of the Entity Framework provider type 'System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.99.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' did not return an object that inherits from 'System.Data.Entity.Core.Common.DbProviderServices'. Entity Framework providers must inherit from this class and the 'Instance' member must return the singleton instance of the provider. This may be because the provider does not support Entity Framework 6 or later;

Can you please give me a hint what may cause the issue? Thanks a lot!

My app.config file looks like this:

<configuration>
    <configSections>
        <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>
        <defaultConnectionFactory type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6"/>
        <providers>
            <provider invariantName="System.Data.SQLite" 
                      type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite"/>
            <provider invariantName="System.Data.SqlClient" 
                      type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
            <provider invariantName="System.Data.SQLite.EF6" 
                      type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
        </providers>
    </entityFramework>
    <system.data>
        <DbProviderFactories>
            <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" />
            <remove invariant="System.Data.SQLite" />
            <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".NET Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" /></DbProviderFactories>
    </system.data>
    <connectionStrings>
        <add name="ChinookContext" 
             connectionString="Data Source=|DataDirectory|Chinook_Sqlite_AutoIncrementPKs.sqlite"
             providerName="System.Data.SQLite"/>
    </connectionStrings>
</configuration>

I have following components installed:

EF 6.0.0
System.Data.SQLite 1.0.99
System.Data.SQLite.Core 1.0.99
System.Data.SQLite.EF6 1.0.99
System.Data.SQLite.Linq 1.0.99

Nkosi · Accepted Answer · 2017-09-11 09:26:20Z

4

Finally i figure out the issue.

Remove sqlite niget packages
Installed EF6 pack
Installed nuget pack System.Data.SQLite 1.0.99 (It will install all necessary dependencies)
did some correction with app.cong file listed below
```
<?xml version="1.0" encoding="utf-8"?>
```

And make sure:

SQLite dlls in references tab refer to dlls within your project. If you installed SQLite from the official site it make some mess with references...
Check app.config file after installing packages. Make sure DBprovider, EntityFramework and Connecstion string sections mathces to list above.
Use data anatation keys like [Table"Artist"] and ["Key"] in model classes. (include using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema;)

Good luck! Hope this will be usefull some of us/you

edited Sep 11, 2017 at 9:26

Nkosi

249k38 gold badges472 silver badges506 bronze badges

answered Feb 16, 2016 at 17:22

Riddik

3,0231 gold badge14 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

cdescours Over a year ago

thanks you saved my day, and avoid me struggling with those dependencies :)

Collectives™ on Stack Overflow

How SQLite and Entity Framework 6 combine

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related