Hi, My procedure returns 2 recordsets, but in my DataSet I have only one Table.
Follow the Example:
The procedure "pr_ReturnTwoRecs" has the return: ResultSet1: id_user = 15
ResultSet2: id_attendance = 15000
[SqlTest] [SqlExecuteProcedure("pr_ReturnTwoRecs", ResultsPropertyName = "Results")] public void Classificacao_HappyDay() { Assert.AreEqual(15, Results.Tables[0].Rows[0][0]); Assert.AreEqual(15000, Results.Tables[1].Rows[0][0]); }
But the DataSet "Returns" has only one table (Tables[0]).
Can anyone help me?
Log in to post a comment.
Hi,
My procedure returns 2 recordsets, but in my DataSet I have only one Table.
Follow the Example:
The procedure "pr_ReturnTwoRecs" has the return:
ResultSet1:
id_user = 15
ResultSet2:
id_attendance = 15000
[SqlTest]
[SqlExecuteProcedure("pr_ReturnTwoRecs", ResultsPropertyName = "Results")]
public void Classificacao_HappyDay()
{
Assert.AreEqual(15, Results.Tables[0].Rows[0][0]);
Assert.AreEqual(15000, Results.Tables[1].Rows[0][0]);
}
But the DataSet "Returns" has only one table (Tables[0]).
Can anyone help me?