Models for a database – objects

To interact with a database (at least for what is being discussed in this chapter), we need a template, which will be the equivalent of the fields in the database tables.

The process is very simple. Let's create an object for each table in our database; regardless of whether it is SQL Server or PostgreSQL, we will only have one object per entity:

• users
• products
• customers

The users object

The idea to facilitate the maintenance and reading of the code is to separate a unit for each entity. In this case, we will need to create three new units for each table. To do so, follow these steps:

1. Open the Delphi IDE.
2. Create a new VCL project.
3. Create three new units (File | New | Unit - Delphi...