public static string GetString(this DbDataReader reader, string columnName) { int columnIdx = reader.GetOrdinal("columnName"); return reader.IsDBNull(columnIdx) ? null : reader.GetString(columnIdx); }