Problems using Entity Framework 6 and SQLite

by

Just thought I’d share another way to configure EF6 with SQLite without using app.config / web.config. EF6 now supports code based configurations as outlined here on msdn. I used the following code (updated to remove reflection thanks to Sly):

public class SQLiteConfiguration : DbConfiguration
{
    public SQLiteConfiguration()
    {
        SetProviderFactory("System.Data.SQLite", SQLiteFactory.Instance);
        SetProviderFactory("System.Data.SQLite.EF6", SQLiteProviderFactory.Instance);
        SetProviderServices("System.Data.SQLite", (DbProviderServices)SQLiteProviderFactory.Instance.GetService(typeof(DbProviderServices)));
    }
}

I use this so I can inject the correct DbContext and hence DbProvider at runtime and don’t need everything configured in the main assembly.

Edit:

As Reyn said you will also need to add an IDbConnectionFactory for SQLite if you wish to have your connection string in your web.config / app.config file. Another approach is to call a different base constructor from your DbContext which passes in a new SQLiteConnection rather than the connection string, as shown in this answer.

More Related Contents:

  1. How does the SQLite Entity Framework 6 provider handle Guids?
  2. How can set a default value constraint with Entity Framework 6 Code First?
  3. VB Net Class in C# [closed]
  4. What ‘additional configuration’ is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project?
  5. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  6. A circular reference was detected while serializing an object of type ‘SubSonic.Schema .DatabaseColumn’.
  7. The cast to value type ‘Int32’ failed because the materialized value is null
  8. Making Entity Class Closed for Changes
  9. How to filter “Include” entities in entity framework?
  10. Filter/Search using Multiple Fields – ASP.NET MVC
  11. Entity Framework 6: audit/track changes
  12. EF Data Context – Async/Await & Multithreading
  13. Why would try/finally rather than a “using” statement help avoid a race condition?
  14. Retrieve an object from entityframework without ONE field
  15. How can I disable model compatibility checking in Entity Framework 4.3?
  16. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  17. DbContext discard changes without disposing
  18. Entity Framework 4: How to find the primary key?
  19. .Include() vs .Load() performance in EntityFramework
  20. Max return value if empty query
  21. Group by with multiple columns using lambda
  22. How to do an “in” query in entity framework?
  23. How to Specify Primary Key Name in EF-Code-First
  24. big issue in converting string to datetime using linq-to-entities
  25. Entity Framework: Duplicate Records in Many-to-Many relationship
  26. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  27. How to force LINQ Sum() to return 0 while source collection is empty
  28. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  29. How to include() nested child entity in linq
  30. LINQ Query to Convert string to datetime

Leave a Comment