Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
3 Cards in this Set
- Front
- Back
|
There are four layers to data access in ADO.NET:
|
The physical data store
This can be a SQL, an OLE, or an Oracle database or an Extensible Markup Language (XML) file. The data provider This consists of the Connection object and command objects that create the in-memory representation of the data. The data set This is the in-memory representation of the tables and relationships that you work with in your application. The data view This determines the presentation of a table in the data set. You typically use data views to filter or sort data to present to the user. Each data set has a default data view matching the row order used to create the data set. |
|
|
There are currently three types of database connection in ADO.NET:
|
1. Use an OleDbConnection object to connect to a Microsoft Access or third-party database, such as MySQL.
2. Use a SqlConnection object to connect to a Microsoft SQL Server database. 3. Use an OracleConnection object to connect to Oracle databases. |
|
|
ADO.NET Namespaces
|
System.Data
System.Data.SqlClient System.Data.OracleClient System.Data.OleDb |
