HELP. Using Entity Framework with both SqlServer and SqLite

I am pulling my hair out at this point, I've been working on this for hours and I cannot figure out what is going wrong. I have a SQL Server database and a SQLite database and I want to use EF with both of them. I've installed the System.Data.SQLite NuGet package which contains System.Data.SQLite.Core, System.Data.SQLite.Linq, and System.Data.SQLite.EF6. I'm able to communicate with the SQL Server database fine but When I try adding to the SQLite database it always fails. It seems to be using the System.Data.Entity.SqlServer reference instead of the System.Data.SQLite.EF6 reference. How to I get it to use the right reference?

The connection string for the local SQLite database is: "Data Source=C:\Users\User1\Desktop\test2.sqlite"

I'm so frustrated at this point!

by dilby33 via /r/csharp

Leave a Reply