May 2002
Beginner to intermediate
560 pages
11h 36m
English
Content preview from Essential ADO.NETBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
10.2. ADO.NET with Server- and File-Based RDBMS
Because of the popularity of relational databases, ADO.NET with server- and file-based RDBMS is what most projects will be using. Like all other generic data APIs, ADO.NET has a data provider architecture based on connections, commands, and transactions. In online transaction processing systems, all you may need is a way to issue commands and obtain results through stored procedure output parameters or as scalar values, especially in systems that involve heavy data entry—for example, Web site signup or sign-on processing.
For queries through large relational databases—using simple queries, multiple results, or join-based results—the DataReader class is optimal. Further optimizations are available ...