public void TestExecuteResultSetsListOfRows()
{
var parameters = DatabaseObjectCreation.CreateResultSetsTestProc(this.connectionType);
try
{
var result = Execute(this.connectionType, DatabaseHelpers.GetDefaultConnectionString(this.connectionType), "Test Proc", parameters, null, true, OutputOption.ListOfRows).Value;
Assert.AreEqual(2, result.Result1Rows.Count);
var row = result.Result1Rows[0];
Assert.AreEqual(1, row.Counter);
Assert.AreEqual("one", row.StringValue);
row = result.Result1Rows[1];
Assert.AreEqual(2, row.Counter);
Assert.AreEqual("two", row.StringValue);
Assert.AreEqual(1, result.Result2Rows.Count);
row = result.Result2Rows[0];
Assert.AreEqual("qwer", row.StringValue);
}
finally
{
DatabaseObjectCreation.RemoveTestProc(this.connectionType);
}
}
public void TestExecuteResultSetsRowByRow()
{
var parameters = DatabaseObjectCreation.CreateResultSetsTestProc(this.connectionType);
try
{
FunctionResult result = Execute(this.connectionType, DatabaseHelpers.GetDefaultConnectionString(this.connectionType), "Test Proc", parameters, null, true, OutputOption.RowByRow);
var executionPathResults = result.ExecutionPathResult.ToList();
Assert.AreEqual(3, executionPathResults.Count());
Assert.AreEqual("Result1", executionPathResults[0].Name);
var row = executionPathResults[0].Value;
Assert.AreEqual(1, row.Counter);
Assert.AreEqual("one", row.StringValue);
Assert.AreEqual("Result1", executionPathResults[1].Name);
row = executionPathResults[1].Value;
Assert.AreEqual(2, row.Counter);
Assert.AreEqual("two", row.StringValue);
Assert.AreEqual("Result2", executionPathResults[2].Name);
row = executionPathResults[2].Value;
Assert.AreEqual("qwer", row.StringValue);
}
finally
{
DatabaseObjectCreation.RemoveTestProc(this.connectionType);
}
}
public void TestExecuteResultSetsFirstRow(
[Values(OutputOption.FirstRow, OutputOption.FirstRowElseEmptyRow)]
OutputOption outputOption)
{
var parameters = DatabaseObjectCreation.CreateResultSetsTestProc(this.connectionType);
try
{
var result = Execute(this.connectionType, DatabaseHelpers.GetDefaultConnectionString(this.connectionType), "Test Proc", parameters, null, true, outputOption).Value;
Assert.AreEqual(1, result.Result1.Counter);
Assert.AreEqual("one", result.Result1.StringValue);
Assert.AreEqual("qwer", result.Result2.StringValue);
}
finally
{
DatabaseObjectCreation.RemoveTestProc(this.connectionType);
}
}
