Home
Browse all 647 examples
Download all 647 examples
Download sample chapters
Reviews
Errata
Acknowledgments
Links on .NET
Paradoxal Press
Buy directly from Paradoxal Press at $33.99 (Save 43%)
Category: Programming
Level: Beginner to seasoned
900 pages
ISBN-10 097661322-0
ISBN-13 978-097661322-0
$59.99 USA
$79.99 CANADA
|
Chapter 19: ADO.NET 2
Chapter 18< > Chapter 20
Listings: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Table of content:
Introduction to databases
DBMS (DataBase Management System)
RDBMS (Relational DataBase Management System)
The SQL language
The need for a distributed architecture
Introduction to ADO.NET
Connected mode vs unconnected mode
Data providers
ADO.NET: The big picture
The DB that we'll use in our examples
Connections and data providers
Decoupling an application and its data providers
Connection strings
How and where to store connection strings?
Connection pool
Access metadata of your data source
Working in connected mode with DataReader
Fetching data from database with DataReader
Getting a scalar computed on the database side
Modifying data with SQL queries
Working in unconnected mode with DataSet
Filling a cache with data fetched from a database
Working with relations between tables of a DataSet
Storing in the database data updated inside a DataSet
Unconnected mode and optimistic/pessimistic concurrency strategies
Constraints on the tables of a DataSet
The DataView class
Typed DataSet
Creating a typed DataSet class
TableAdapter and typed SQL requests
Bridges between the connected and the unconnected modes
Bridges between objects and the relational data
Structural problems
Behavioral problems
Three different approaches to solve these problems
Object/relational mapping .NET tools
Functionalities specific to the SQL Server data provider
Asynchronous requests
Bulk copy
Statistics on SqlClient connections
SQL Server 2005 Express Edition
Copyright Patrick Smacchia 2006 2007
|