Treating Boolean fields in Sqlite as Boolean in C#
I have created a table in a SqLite table using the following
create table test1 ( ID int not null primary key, Processed BOOLEAN NOT NULL CHECK(Processed IN (0, 1)) )
And this appears to work as below
But when I switch Languages from SQL to C# this becomes a string
I have the connection set as
Am I doing something wrong?
EF Core Version 6.0.5