O'Reilly logo

Essential ADO.NET by Bob Beauchemin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required