I wasn’t aware of it, until now anyway…
using (SqlConnection conn = new SqlConnection(“your-connection-string”))
string query = “SELECT * FROM T1; SELECT * FROM T2;”;
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader reader = cmd.ExecuteReader();
// read each row in the statement results.
while(reader.NextResult()); // jump to the next statement results.
One thought on “Parsing batch of T-SQL statements via IDataReader”
I saw the NextResult() method before, but I didn’t know what it did.
Any idea how to do this on Oracle? It just throws an error at you if you try to pass a ‘;’ to the command.
Comments are closed.