The C# ?? null coalescing operator (and using it with LINQ)
Published: 20 Sep 2007
Unedited - Community Contributed
This article examines the usage of ?? null coalescing operator in C# using LINQ.
by Scott Guthrie
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 27676/ 128


Republished with Permission - Original Article

One of the subtle (but cool) language features of C# is the ?? "null coalescing" operator.  This provides a nice, terse way to check whether a value is null, and if so return an alternate value.

Simple Example Usages

Several folks have blogged about the ?? operator in the past - read here, here, here, and here for some previous examples on how to use it.  Simply put, the ?? operator checks whether the value provided on the left side of the expression is null, and if so it returns an alternate value indicated by the right side of the expression.  If the value provided on the left side of the expression isn't null, then it returns the original value. 

For example, let's assume we have a string variable "message".  We could check whether message was null, and return an alternate value using the code below:

Figure 1

Because the "message" variable above wasn't null, the "result" variable is assigned the original "hello world" message value. 

In the code snippet below, however, message is a null value, and so the ?? operator will return the alternate value we've provided:

Figure 2

The ?? operator works for both reference types and value types.  For example, below we are checking whether the nullable integer "number" variable is null.  Because it isn't, the result will be the original value (55):

Figure 3

If "number" is null, then result is assigned the value 0:

Figure 4

Using the ?? operator with LINQ

Last month I wrote a blog post that covered using the new LINQ to XML support in .NET 3.5.  One of the "gotchas" you often need to deal with when handling raw XML are cases where XML shapes are irregular and/or missing elements/attributes.  The ?? operator can be very useful in these scenarios.

For example, let's consider a scenario where we have an XML file or feed with the following contact data:

Figure 5

We could write the below LINQ to XML code in C# to open the XML file and retrieve back a sequence of anonymous type objects with "Name", "Title", "Email" and "YearsAtCompany" properties, and then databind the results to an <asp:gridview> control on a page:

Figure 6

Notice above how I'm using the explicit conversion operator support on the XElement class to retrieve strongly typed values from the XML.  This enables me to just cast the c.Element("YearsAtCompany") value to an int - and it will then automatically convert the string value to an integer for me, and type the "YearsAtCompany" property on my anonymous type to be an int.

When we run the above code snippet, we'll then get a nice Gridview listing of our contacts:

Figure 7

This explicit conversion support works great when the <YearsAtCompany> element is always defined.  But it will throw a runtime error in the case where we have a <Contact> that is missing a <YearsAtCompany> sub-element:

Figure 8


One way to fix this is to modify our LINQ to XML query so that we indicate that YearsAtCompany is a nullable integer.  We can do this by changing the explicit cast to be (int?) instead of (int):

Figure 9

This enables our query to execute cleanly and not raise any errors.  Instead a null value will be assigned to the YearsAtCompany property if no <YearsAtCompany> element is present in the XML. 

When we run the application and databind the results to the Gridview, you can see the YearsAtCompany column for our third contact is empty as a result (since the value is null):

Figure 10

But what if we didn't want a missing XML value to result in a null integer value - but instead just indicate a value of 0? 

Well.... that is where we can use the new ?? operator support.  We can just modify the LINQ to XML query like below to indicate a default value of 0 if no element is present:

Figure 11

This indicates that if the <YearsAtCompany> element is missing in the XML, and the result would otherwise be null, instead assign a value of 0.  Notice in the intellisense above how C# automatically detects that this means that the YearsAtCompany property on the new anonymous type will never be null - and so it marks the property to be of type (int) instead of (int?). 

And now when we run the page we'll see a value of 0 show up in our third row instead of a blank value:

Figure 12


You can use the C# ?? operator in all types of scenarios.  Hopefully the LINQ to XML scenario above provides some interesting food for thought on how you can use it with any LINQ scenario (including LINQ to SQL, LINQ to XML, LINQ to Objects, LINQ to SharePoint, etc).  

Hope this helps,



User Comments

Title: C # Linq   
Name: Faheem
Date: 2009-05-21 7:43:20 AM
say i have 300 xml elements and 250 may or may not have their values in xml file then it will be very tedious for me to write all element name and using ? style as u mention . IS there any method which is universal and easy to use.
Title: ASP .Net   
Name: raja
Date: 2007-10-05 3:36:50 AM
detail Above session

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2018  |  Page Processed at 2018-10-23 9:45:22 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search