SqlDataReader.HasRows Problems
For the last 6 years or so at work, we have had an intermittent bug. In this case, intermittent means around once in 6 months or so. A little background to the problem first: Our data access is done via what was originally Microsoft’s SQLHelper class, passing in a stored procedure (and parameters), and our entities use the reader to load all their properties. Pretty straight forward stuff. The problemis, on the live system, every few months a sproc will stop returning results, for no apparent reason....