Framework solution
The database solutions break down into the following three areas:
Dealing with database connections and related information
Services to carry out data operations
Creation of objects connected with database rows
But first there is the question of the class structure needed to implement those mechanisms.
Class structure
Before embarking on details of database classes, it may be helpful to give a brief comment on the terms used. Talk of a database can be rather vague. In these discussions, a database is the entity known to a database server as a specific, named collection of tables. A database will have one or more users, and a database connection is made by contacting the server with the credentials of one of those users. Commonly, a program will need exactly one database connection for one database. A database server is an implementation of software that manages one or more databases, accepting queries, and returning results. When there is mention of more than one database,...
