private static void ProcessQueries(InputParameters InputParams, string ConnectionString)
{
using (SqlConnection _Connection = new SqlConnection(ConnectionString))
{
if (InputParams.MessagesFile != String.Empty)
{
Helpers.Debug("Setting up the MessagesFile and handler.");
// clear out existing file
File.Delete(InputParams.MessagesFile);
Capture.MessagesFile = InputParams.MessagesFile;
Capture.OutputEncoding = InputParams.OutputEncoding;
_Connection.InfoMessage += Capture.InfoMessageHandler;
}
_Connection.FireInfoMessageEventOnUserErrors = false;
using (SqlCommand _Command = _Connection.CreateCommand())
{
_Command.CommandType = CommandType.Text;
_Command.CommandTimeout = InputParams.QueryTimeout;
if (InputParams.RowsAffectedDestination != String.Empty)
{
Helpers.Debug("Setting up the RowsAffected handler.");
_Command.StatementCompleted += Capture.StatementCompletedHandler;
}
_Connection.Open();
ResultsOutput _Output = null;
QueryBatches _Queries = null;
try
{
_Queries = new QueryBatches(InputParams);
_Output = Helpers.GetResultsOutput(InputParams);
while (_Queries.NextBatch())
{
_Command.CommandText = _Queries.GetBatch();
Helpers.Debug("Executing the batch...");
try
{
using (SqlDataReader _Reader = _Command.ExecuteReader())
{
object[] _ResultRow;
string _OutputRow;
do
{
_Output.Send(_Output.GetHeader(_Reader, InputParams.ColumnSeparator));
if (_Reader.HasRows)
{
_ResultRow = new object[_Reader.FieldCount];
while (_Reader.Read())
{
_Reader.GetValues(_ResultRow);
_OutputRow = String.Join(InputParams.ColumnSeparator, _ResultRow);
_Output.Send(_OutputRow);
}
_ResultRow = null;
}
else
{
_Output.Send($"[EXECUTED]:\n { _Command.CommandText }");
}
} while (_Reader.NextResult());
} // using (SqlDataReader...
}
catch (SqlException ex)
{
_Output.Send(String.Concat("[ERROR]:\n", $"{_Command.CommandText}\n", ex.Message, "\n\n",
"Error Number: ", ex.Number, "\n",
"Error Level: ", ex.Class, "\n",
"Error State: ", ex.State, "\n",
"Error Procedure: ", ex.Procedure, "\n",
"Error Line: ", ex.LineNumber, "\n",
"HRESULT: ", ex.ErrorCode, "\n"
));
}
} // while (_Queries.NextBatch())
}
//catch
//{
// throw;
//}
finally
{
if (_Output.GetType() == typeof(OutputFile))
{
Helpers.Debug("Close output file!");
_Output.Dispose();
}
}
} // using (SqlCommand...
} // using (SqlConnection
return;
}