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 ...
Get Essential ADO.NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
