c＃IDataReader SqlDataReader的区别

using (IDataReader reader = cmd.ExecuteReader())
{
    while (reader.Read())
    {
        // get data from the reader
    }
}

using (SqlDataReader reader = cmd.ExecuteReader())
{
    while (reader.Read())
    {
        // get data from the reader
    }
}

SqlDataReader

IDataReader

IDataReader

SqlDataReader

IDbConnection

IDbCommand

IDataReader

HasRows

Create...()

IDbCommand command = myDbConnection.CreateCommand();

SqlCommand command = new SqlCommand(myDbConnection);

DbConnection

DbDataReader

HasRows