Summary

The ADO.NET components offer a variety of mechanisms for data access from Visual Basic .NET. In this chapter we have examined both .NET Data Providers and DataSet components. Specifically, we covered the following:

  • Connecting to a database

  • Issuing queries against a database connection and processing the resultsets

  • The differences between direct database access through data providers and indirect access through data cached in a DataSet

  • Creating a DataSet from scratch; adding tables, columns, relationships, and constraints to build our own in-memory database

  • Executing stored procedures and dealing with input, output, and return parameters

  • Placing queries inside transactions

Get Visual Basic® Programmer's Guide to the .NET Framework Class Library 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.

Start your free trial