Summary

This chapter presented the ADO.NET classes and features they provide. We connect to the database using the ADO.NET Connection object of the relevant data provider. We have two options of working with a database: connected mode and disconnected mode. The former represents the classic ADO model. With the latter we may achieve better performance for our database applications, since we may perform the operations on data locally and then propagate changes to the database.

When working in connected mode, we use data readers to fetch the data. In the disconnected mode, the data is placed in the datasets that are independent of any data provider. Data adapters mediate between the database and dataset when transferring data from and to a database. ...

Get Programming PERL in the .NET Environment 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.