Treating Boolean fields in Sqlite as Boolean in C#

sgmoore · June 2022

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?

LinqPad 7.4.3
EF Core Version 6.0.5
.Net 6.0.6