How does SqlDataReader return multiple recordsets?

cqpzj7788

CommandBehavior default in enum

This query may return multiple result sets. Executing queries may affect the state of the database. Default does not set the CommandBehavior flag, so calling ExecuteReader (CommandBehavior.Default) is functionally equivalent to calling ExecuteReader ().

——It feels like a SqlDataReader should return one. How to return multiple result sets by default? How to return?

makoto369

sqldatareader can only return one record set, to RECORDSET in ADO
To return more than one, try DATASET