Nullable Types in .NET Framework

Within the .NET Framework data types such as Boolean can either be true or false. Right?  Well, with the release of 2.0 Framework it has been possible to create nullable data types.  A nullable type can represent all the values of the underlying type plus empty (or undefined).  In the case of our Boolean it would be True/False and Nothing.

It is only possible to create a nullable types Nullable(Of T) for value types since the default value for reference types is already nothing.  The following types are valid as nullable: Boolean, Byte, Int16, Int32, Int64, Single, Double, Decimal, DateTime.  The following examples show examples on how to create a nullable variable type:

Dim success as New Nullable(Of Boolean)()

Dim customerId as New Nullable(Of Integer)()

With the release of .NET 3.5 it is also possible to use the short form versions:

Dim success as Boolean?
Dim customerId as Integer?

In C#

bool? success;
int? customerId;

To check of a nullable type as a value it is possible to use the HasValue  or Value properties.  Use the System.Nullable.GetValueOrDefault property return either the assigned value, or the default value for the underlying type.  

If customerId.HasValue Then
  ‘do something
End If

If assigning a nullable type to a non-nullable type you must cast operator is necessary.  For example:

int newCustomerId = (int)customerId;  // in C#

Nullable types can be useful when dealing with NULL values from a database query however they are not the same.  That is to say that DBNULL value is not the same as Nothing.  When returning data from the database the following code will be necessary:

int? customerId = null;

if (!DBNULL.Value.Equals(reader[“CustomerId”])){    // this code converts the DBNULL to a c# null
  customerId = (int)reader[“CustomerId”];
}


Author

Admin

comments powered by Disqus

Categories

Recent Tweets

"Setting up and Getting Started with Power BI Embedded | Data Exposed" channel9.msdn.com/Shows/Data-Exp… #webcast #feedly
Retweeted by @dyardy @scottgu @victoriabeckham Worlds collide, double take on that photo!
@scottgu @victoriabeckham Worlds collide, double take on that photo!
@projectedxyz It is really easy, what are you doing (isn't this data which on the web)