private static bool AdvanceToNextRow(SqlDataReader reader) { Debug.Assert(reader != null && !reader.IsClosed); // this method skips empty result sets do { if (reader.Read()) { return true; } } while (reader.NextResult()); // no more rows return false; }