Quote
The connector must be in use hundreds of thousands of times
Exactly, the problem you're having must be local to your setup.
Quote
One statement is fine, as long as I don't append an ORDER BY. After doing this the expected resultset shrinks from over 8k rows to 1 row - only
reproducable executed via this connector.
Ah, it's responding as if you'd specified CommandBehavior.SingleRow. Did you try other CommandBehavior settings?
Does this happen if you don't override ExecuteReader?
If it's me, I add in code to ...override ExecuteReader... tracking how many rows the query returned, where their buffer is &c.
Edited 2 time(s). Last edit at 05/30/2020 04:52PM by Peter Brawley.