B.1. Using ADO.NET to access data

ADO.NET is a technology that enables physical interaction with a database. Internally, it leverages Component Object Model (COM) providers, but it exposes functionalities through .NET classes. Most of the complexity of communicating with the database is stripped away, and you only have to deal with ADO.NET classes.

Even if working with classes is somewhat hard, you can do lots of things to simplify the process of retrieving data and pouring it into objects. The reverse process has the same issue; persisting entities data into a database is code expensive. You have to create and open a connection to the database, issue the commands, process the result, and close the connection. This flow is shown in figure B.1.