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));
}
}
