Home

Nullable BIT fields in "Results to Grid"

When executing the following code in C# expressions mode, LINQPad correctly shows the null entry as a indeterminate checkbox:

new bool?[] { true, false, null }

when executing the following code in SQL mode (with LINQPad's default LINQ to SQL driver, connecting to the SQL Server provider), LINQPad shows the null entry as though it was false:
DECLARE @Checkbox TABLE (Boolean BIT NULL)

INSERT INTO @Checkbox VALUES (1), (0), (NULL)

SELECT *
FROM @Checkbox
this is with v5.28.04. Is there any chance this could be "fixed", please? :)

image

Comments

Sign In or Register to comment.