Download ADO.NET E-book. Everything about Accessing Data with Ado.NET

jack | Views: 1421

Data Access with ADO.NET This free e-book is about ADO.NET and written by .NET experts like Dr. Herbert Praehofer and Dr. Dietrich Birngruber. It describes everything about Accessing Data with Ado.NET and contains Important ADO.NET Interview Question and Answers. This e-book covers overall important topics regarding ADO.NET like Architecture of ADO.NET, Data Providers, ADO.NET Assembly and Namespaces, Dataset, DataRow, Integration Datasets and XML. So download free e-book and get complete tutorial of ADO.NET.


Overview of ADO.NET e-book:

Introduction
1) Idea of the Universal Data Access API
2) Data Providers
3) History of Universal Data Access
4) Architecture of ADO.NET
5) Connection-oriented versus Connectionless
6) ADO.NET Assembly and Namespaces

Connection-Oriented Access
1) Architecture
2) Class Hierarchy
3) Program Pattern for Connection-oriented DataAccess
4) Interface IDbConnection
5) IDbConnection: Property ConnectionString
6) Command Objects
7) Interface IDbCommand
8) ExecuteReader Method
9) ExecuteNonQuery Method
10) ExecuteScalar Method
11) Parameter
12) Working with Parameters
13) Isolation Levels for Transactions
14) DataReader
15) Interface IDataReader

Connectionless Access
1) Motivation and Idea
2) Microsoft 3-Tier Architecture
3) Architecture of Connectionless Data Access
4) DataSet
5) DataSet Structure
6) DataSet Class Diagram
7) DataSet: Change Management
8) State Diagram of a DataRow object
9) DataRowVersion
10) Exception Handling
11) DataView
12) Working with DataView

Database Access with DataAdapter
1) Architecture
2) DataAdapter Class Diagram
3) DataAdapter: Loading Data
4) DataAdapter: Loading Schema and Data

Integration with XML
1) Integration DataSets and XML
2) Writing and Reading XML Data
3) DataSet and XML Schema
4) Typed DataSets
5) Access to DataSets using XML-DOM

Preview of ADO.NET 2.0

Summary

Tags:  ADO.NET  .Net Framework  DataSet  DataReader

 
Register or Login to Post Your Comment/Opinion