IDataReader与SqlDataReader的区别 [英] IDataReader , SqlDataReader difference

问题描述

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
            }
        }

有人可以告诉我这两段代码之间的区别吗?为什么使用IDataReader?

Hi,

Can someone tell me the difference between these two pieces of code ? Why use IDataReader ?

推荐答案

IDataReader是SqlDataReader的类，而SqlDataReader是类的....如果您有Visual Studio，则可以在对象浏览器中看到它.
有关更多详细信息，请访问...
Link1 [ Link2 [

IDataReader is an InterFace while SqlDataReader is class.... you can see it in the Object browser if you have Visual Studio....
for more details visit...
Link1[^]
Link2[^]

IDataReader是所有数据读取器都实现的通用接口(包括SqlDataReader).除了使用基本接口，您无需更改任何代码即可轻松更改数据库提供程序(例如从SQL Server切换到Oracle)，您的代码就没有什么区别.

IDataReader is the generic interface that all data readers implement (including SqlDataReader). There is not much difference in your codes except that using the base interfaces allow you to change the database provider easily without any code change (like switching over from SQL Server to Oracle).

SqlDataReader是对于仅使用as的Sql Server，IdataReader用于所有关系数据库.

SqlDataReader is For only Sql Server where as ,IdataReader is used for all the Relational databases.

这篇关于IDataReader与SqlDataReader的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！