0.1 Introduction to ADO.net

Question 1

What is ADO.net?

Answer 1

It is a set of classes in C# that allows us to connect to, and work with data sources like databases, xml files, excell files, etc.

Question 2

What is a Data provider?

Answer 2

It is a set of components that allows a specific data source to be accessed in a managed way.

Question 3

What are the two main protocols used by data providers in ADO.net?

Answer 3

ODBC, OleDb

Question 4

List 5 data Providers, the api prefixes, and their descriptions.

Answer 4

1. ODBC, Odbc, “Used to access older databases”
2. OleDB, OledDB, “Used to access data sources with an OleDB interface, like access, and excell files”
3. Oracle, Oracle, “Used to access Oracle databases”
4. SQL, SQL, “Used to access microsoft SQL server”
5. Borland, Bdp, “A generic way to access access data sources”

Question 5

What are the four components of data providers, and the classes associated with them?

Answer 5

1. Connection: Connecting to the data source, using the DbConnection class.
2. Command: Sending queries to the data source, using the DbCommand class.
3. Data Reader: Reading data from the data source in a read-only manner, using the DbDataReader class.
4. Data Adapter: Invoking and updating datasets from the data source, using the DbDataAdapter class.