How to check column name exists in SqlDataReader object

Try creating extension method as below example. 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; } } https://www.codeproject.com/Questions/256824/How-to-check-if-a-column-exists-in-a-datareader