public static string ExecuteQueryToDisplayString(string query, string connectionString, Func <SqlCommand> commandCreator) { if (String.IsNullOrEmpty(query)) { return(String.Empty); } try { string[] dataset = null; var headers = new StringBuilder(); if (connectionString != null) { dataset = DatabaseUtils.Query(query, connectionString, r => ConvertRowToString(r, headers)).ToArray(); } else if (commandCreator != null) { dataset = DatabaseUtils.Query(query, commandCreator, r => ConvertRowToString(r, headers)).ToArray(); } return(headers + "\r\n" + String.Join("\r\n", dataset)); } catch (Exception ex) { return(LoggerInstance.FormatExeption(ex)); } }