protected SqlResult ExecuteReader(
IDbConnection connection,
string commandText,
int timeLimit = DefaultTimeLimit)
{
using (var command = connection.CreateCommand())
{
command.CommandText = commandText;
using (var reader = command.ExecuteReader())
{
var sqlTestResult = new SqlResult();
sqlTestResult.Completed = CodeHelpers.ExecuteWithTimeLimit(
TimeSpan.FromMilliseconds(timeLimit),
() =>
{
do
{
while (reader.Read())
{
for (var i = 0; i < reader.FieldCount; i++)
{
var fieldValue = this.GetDataRecordFieldValue(reader, i);
sqlTestResult.Results.Add(fieldValue);
}
}
}while (reader.NextResult());
});
return(sqlTestResult);
}
}
}
protected bool ExecuteNonQuery(IDbConnection connection, string commandText, int timeLimit = DefaultTimeLimit)
{
using (var command = connection.CreateCommand())
{
command.CommandText = this.FixCommandText(commandText);
return(CodeHelpers.ExecuteWithTimeLimit(
TimeSpan.FromMilliseconds(timeLimit),
() => command.ExecuteNonQuery()));
}
}