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?

LinqPad 7.4.3
EF Core Version 6.0.5
.Net 6.0.6

Sign In or Register to comment.