private static string[] GetColumnNames(IDataReader dr, int numberOfColumns) { var colNames = new List<string>(); for (int i = 0; i < numberOfColumns; i++) { colNames.Add(dr.GetName(i)); } return colNames.ToArray(); }