It turns out that I have a stored procedure where I return two selects, simply and simply like doing a SELECT * FROM [NombreTabla] , one below the other.
I from C # what I do is receive it with a DataSet in the following way:
var result = await db.SqlProcedure<DataSet>("Procedimiento").ToListAsync();
result returns a list with two elements, each element looks like this:
System.Data.DataSet
Within each one I have many properties, but there is one in particular that is the one that concerns me: Tables .
Within each there is a Count that always equals 0 and a ResultView() that tells me that the enumeration did not produce any results, and this is where you should be able to see both selects.