Nullable BIT fields in "Results to Grid"

kingkeith

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?

JoeAlbahari

Thanks for the bug report. I'll try and get this into the next build.

JoeAlbahari

Try the new beta:
http://www.linqpad.net/Download.aspx#beta

kingkeith

Thanks Joe, I can confirm it now works in SQL mode correctly.
I found one more place where it still shows as unchecked - in C# Expressions mode, using the same database connection, querying a table, clicking on a Foreign Key Hyperlinq to a different table and then on a Hyperlinq back to the original record:



(in this case, my specific original query was Clients.Where(c => c.ClientID == 1722).Select(c => new { c.Gender, c.ClientCards })