EntityFramework.SqlServerCompact | Entity Framework Core SQL Server Compact provider | SQL Database library

I'm getting red pixels added to my uploaded images - using ImageResizer 4.2.5. After reading a bunch of posts about this same issue, I am none the wiser with actually understanding how their licencing works - nor why the version I'm using is violating any licencing - I'm after the bare bones free version (which is what I thought I was using).

Any help would be appreciated. A slightly confused newbie.

Below is their output ...

I am using EntityFramework.SQLServerCompact nuget package in my WPF app.

It does work partially, e.g:

It does run ToList().

It doesn't run Where() query and it show this exception:

SqlCeException: The specified argument value for the function is not valid. [ Argument # = 3,Name of function(if known) = case ]

When I run this following query:

What is the difference between SqlServerCe and SqlClient code? Does EF code first require SqlServerCe, or is it capable of SqlClient also? What provider should I choose if I am operating on a local database?

My app.config looks like this:

I have a project using SqlServerCe.3.5 with EntityFramework 6. I want to change the database to PostgreSQL so I changed the configuration

From:

I have a simple ASP.NET application using EntityFramework and a SQL Server EF DB.

The problem is that if I try to use SQL CE (Compact Edition), my application services throws an exception on the second call to the repository with the error:

ExecuteReader requires an open and available Connection.

All works successfully if I return to a SQL Express database.

Here the step and code I used:

Modification to the client application App.config file (I report only changes):

I am trying to move my app.config ef settings to code.

Im using win10, vs2017.
I created a new project, then added nuget "System.Data.SQLite".
Next, I installed "sqlite-netFx46-setup-bundle-x86-2015-1.0.105.2.exe" from system.data.sqlite.org with fullInstall options and checkboxes.
I rebooted the PC.
Then in the Visual Studio Server Explorer, I connected a new SQLite Database.
Further added "ADO .Net Entity Date Model", added Entity and used "Generate DB from model"
Im getting this error:
App.config:

I have no idea, where should I set up System.Data.Entity.DropCreateDatabaseAlways parameter in my App.config file.

I do understand, that config section named "entityFramework" is defined here. I presume this section should be used. But I can't find any example of this type App.config file.

I'm using EF6.0 and SqlServer Compact.

I'd like to provide an option to use LocalDb or embedded database in my application. Installed EF 6, EntityFramework.SqlServerCompact and Microsoft.SqlServer.Compact packages.

Here is what I have in App.config: