SqlDataReader.Read() always returning false

Question

I have the following situation:

using (SqlConnection conexao = new SqlConnection(ConnectionString))
{
    SqlCommand comando = new SqlCommand(query, conexao);
    comando.Parameters.AddWithValue("id", idUsuario);
    conexao.Open();
    SqlDataReader reader = comando.ExecuteReader(CommandBehavior.SingleRow);
    if (reader.Read())
    {
        Hydrate(out entity, reader);
    }
}

So, if reader contains valid results and HasRows == true, then reader.Read() should return true, right?

Well, it doesn't for me. I have no idea of what is going on, because the Hydrate(out entity, reader); line is never getting hit.

Can someone please help me understand this?

Thank you!

Erich · Accepted Answer · 2009-10-08 21:31:48Z

11

Actually, what happens is SqlDataReader.Read returns true if it is NOT the last row.

Your behavior specifies "SingleRow", so the reader aligns the reader to the first row, and returns false saying "there are no rows left after this one".

See this link Here for the documentation on this: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.read.aspx

"true if there are more rows; otherwise false."

Of interest, however, their examples seem like they would ignore the very last row based on that sentence...

answered Oct 8, 2009 at 21:31

Erich

3,9721 gold badge25 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shaggie Over a year ago

I know this is old, but in case anyone else reads this, I feel this could be misleading. Microsoft's documentation (in the Remarks) says

The default position of the SqlDataReader is before the first record. Therefore, you must call Read to begin accessing any data.

I take this to mean calling Read returns true when there is a row to read (the row pointer is at a valid row). If you are on the last row and call Read it will return false because there is nothing after, but if you are on the second last and call Read, it will return True and move the row pointer to the last row.

Collectives™ on Stack Overflow

SqlDataReader.Read() always returning false

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related