?? operator didn't trigger System.DBNull type in DataTable DataRow

Question

This is a follow-up question to .Net C# String.Join how to output “null” instead of empty string if element value is null? where the answer suggested to use the ?? operator to define a custom null value, but the replacement never got triggered.

DataSet myDataSet = new DataSet();
mySqlDataAdapter.Fill(myDataSet);
DataTable rotationData = myDataSet.Tables["Table"];

rotationValues = string.Join(", ",
    from r in rotationData.Rows.OfType<DataRow>()
    select r[5] ?? "null");

When I change the code to:

rotationValues = string.Join(", ",
    from r in rotationData.Rows.OfType<DataRow>()
    select r[5].GetType());

I can observe that the data type for elements that have valid data in them is System.Double whereas the data type for elements which are NULL is System.DBNull. Does ?? not operate on System.DBNull?

Magnus · Accepted Answer · 2013-05-18 08:10:50Z

7

No DBNull and null is not the same thing. But you can write this instead:

select r[5] == DBNull.Value ? "null" : r[5]);

Another possibility is to use Field extension method, it will give you strongly-typed access to each of the column values in the specified row, and the ?? operator will work.

select r.Field<string>(5) ?? "null";

edited May 18, 2013 at 8:10

answered May 18, 2013 at 7:55

Magnus

47.3k8 gold badges88 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Augusto · Accepted Answer · 2013-05-18 08:08:20Z

3

?? operates on the programming language null, not on the database DBNull.

From MSDN:

Do not confuse the notion of null in an object-oriented programming language with a DBNull object. In an object-oriented programming language, null means the absence of a reference to an object. DBNull represents an uninitialized variant or nonexistent database column.

edited May 18, 2013 at 8:08

answered May 18, 2013 at 7:59

Augusto

1516 bronze badges

Collectives™ on Stack Overflow

?? operator didn't trigger System.DBNull type in DataTable DataRow

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related