.net中IDBDataAdapter和IDataAdapter有什么区别

The IDataAdapter interface allows an inheriting class to implement a
DataAdapter class, which represents the bridge between a data source and
a DataSet.

The IDbDataAdapter inherits from IDataAdapter and is specific to when
you're using a relational database as your data source(当数据源为数据库时). Data sources
don't have to be databases, you could have adapters to other external
systems, an XML file, other data files could be data sources as well.

Usually you don't use the interfaces directly (as a type) unless your
code could be one of many different types of datasources or DBs at the
same time. For example, if you have code that needs to run using
SQLServer and/or Oracle in your current environment, and you want it to
be switchable (the same code block run with either type of database).

 

使用这两个接口的场景:当需要有多种类型的数据源或者数据库时,如Sql和Oracle并存.可以采用工厂模式对数据访问做封装.

Or if you have a new type of datasource you'd like to add
DataSet-related capabilities to interact with, you would create classes
based on these interfaces....

或者,如果每次添加一种数据源类型时,需要基于这两个接口创建新的类实现数据访问.