What is the difference between null and System.DBNull.Value?

by

Well, null is not an instance of any type. Rather, it is an invalid reference.

However, System.DbNull.Value, is a valid reference to an instance of System.DbNull (System.DbNull is a singleton and System.DbNull.Value gives you a reference to the single instance of that class) that represents nonexistent* values in the database.

*We would normally say null, but I don’t want to confound the issue.

So, there’s a big conceptual difference between the two. The keyword null represents an invalid reference. The class System.DbNull represents a nonexistent value in a database field. In general, we should try avoid using the same thing (in this case null) to represent two very different concepts (in this case an invalid reference versus a nonexistent value in a database field).

Keep in mind, this is why a lot of people advocate using the null object pattern in general, which is exactly what System.DbNull is an example of.

More Related Contents:

  1. Unity: Null while making new class instance
  2. C# okay with comparing value types to null
  3. What is the difference between Nullable.HasValue or Nullable != null?
  4. Assign null to a SqlParameter
  5. Deep null checking, is there a better way?
  6. DateTime “null” value
  7. What is the difference between “x is null” and “x == null”?
  8. Json Convert empty string instead of null
  9. C#: Passing null to overloaded method – which method is called?
  10. In C#, what happens when you call an extension method on a null object?
  11. How to set enum to null
  12. How do I handle null or optional DLL struct parameters
  13. Easier way of writing null or empty?
  14. Handle DBNull in C#
  15. Shortest way to check for null and assign another value if not
  16. Unique ways to use the null coalescing operator [closed]
  17. How to do ToString for a possibly null object?
  18. Why is “null” present in C# and Java?
  19. Why does .ToString() on a null string cause a null error, when .ToString() works fine on a nullable int with null value?
  20. Best way to check if a Data Table has a null value in it
  21. String.IsNullOrWhiteSpace in LINQ Expression
  22. Check for null in foreach loop
  23. DateTime “null” / uninitialized value?
  24. Nullable types: better way to check for null or zero in c#
  25. string.Empty vs null.Which one do you use?
  26. DBNull if statement
  27. Why does null need an explicit type cast here? [duplicate]
  28. What does exclamation mark mean before invoking a method in C# 8.0? [duplicate]
  29. C# null coalescing operator equivalent for c++
  30. What is the operator precedence of C# null-coalescing (??) operator?

Leave a Comment