Check for column name in a SqlDataReader object

by 
public static class DataRecordExtensions
{
    public static bool HasColumn(this IDataRecord dr, string columnName)
    {
        for (int i=0; i < dr.FieldCount; i++)
        {
            if (dr.GetName(i).Equals(columnName, StringComparison.InvariantCultureIgnoreCase))
                return true;
        }
        return false;
    }
}

Using Exceptions for control logic like in some other answers is considered bad practice and has performance costs. It also sends false positives to the profiler of # exceptions thrown and god help anyone setting their debugger to break on exceptions thrown.

GetSchemaTable() is also another suggestion in many answers. This would not be a preffered way of checking for a field’s existance as it is not implemented in all versions (it’s abstract and throws NotSupportedException in some versions of dotnetcore). GetSchemaTable is also overkill performance wise as it’s a pretty heavy duty function if you check out the source.

Looping through the fields can have a small performance hit if you use it a lot and you may want to consider caching the results.

More Related Contents:

  1. Multiples Table in DataReader
  2. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  3. Get current folder path
  4. Reading 64bit Registry from a 32bit application
  5. Program to find prime numbers
  6. Restarting (Recycling) an Application Pool
  7. How to find the most recent file in a directory using .NET, and without looping?
  8. How to check whether a string is a valid HTTP URL?
  9. Does C# 6.0 work for .NET 4.0?
  10. In C#, how to check if a TCP port is available?
  11. Raise an event whenever a property’s value changed?
  12. How to limit the Maximum number of parallel tasks in c#
  13. How to call a VBScript file in a C# application?
  14. Can you get the column names from a SqlDataReader?
  15. Why do BCL Collections use struct enumerators, not classes?
  16. Absolute path back to web-relative path
  17. Entity Framework with XML Files [closed]
  18. how to convert NameValueCollection to JSON string?
  19. WPF How to access control from DataTemplate
  20. When using a Settings.settings file in .NET, where is the config actually stored?
  21. HttpWebRequest & Native GZip Compression
  22. Identifying a custom indexer using reflection in C#
  23. Initialize library on Assembly load
  24. How to prevent duplicate values in enum?
  25. What is the difference between ManualResetEvent and AutoResetEvent in .NET?
  26. How to register Windows Forms with Simple Injector
  27. A pattern to pause/resume an async task?
  28. Who Disposes of an IDisposable public property?
  29. EPPlus – LoadFromCollection – Text converted to number
  30. Shredding files in .NET

Leave a Comment