You are creating A5P.NET applications by using the .NET Framework 3.5.
The application uses the DataSet and DataAdapter classes to retrieve and update data. Data can be stored in Microsoft SQL Server 2008 databases or in Microsoft Access databases.
You are designing a strategy that allows the application to function appropriately regardless of the database management systems used.
You need to implement the strategy by using the minimum amount of development effort.
What should you do?
A.
Use the System.Data.Common.DbDataFactories and DbDataAdapter classes.
B.
Use the System.Data.SqlConnection and SqlDataAdapter classes.
C.
Use the System.Data.IDbConnection and IDbDataAdapter interfaces.
D.
Implement an abstract base class that defines methods for the data operations that must be performed by the application. Create a class that inherits this abstract class for each kind of database that must be supported by the application. Modify the application to use these classes instead of DataAdapters.
Explanation:
see also http://msdn.microsoft.com/de-de/library/system.data.idbdataadapter.aspx http://www.eggheadcafe.com/microsoft/Csharp/29729416/sqlconnection-vs-idbconnection.aspx and http://msdn.microsoft.com/en-us/library/system.data.idbdataadapter.aspx