[Dev] Map DB Schema to Entity Classes

[RenanKummer]

As a developer, I want to map the database schema to entity classes in Entity Framework Core, So that database objects are created and accessible by the application.

Acceptance Criteria:

• The entity classes and the DbContext are created and configured according to the documented database schema.
• The migration scripts to create the database schema on the database are generated by dotnet-ef tool.
• The generated migration scripts are reviewed and tested on local database.
• The mapping is tested by performing data access operations on local database using the entity classes.

Assumption:

• The database schema has already been defined and documented.

[RenanKummer]

Currently the entities User, Group, Permissions and the many-to-many associations have been correctly mapped.

I faced some challenges with EF Core Fluent API to map the associations since I didn't want to expose redundant ID properties, thus requiring understanding how to use shadow properties.

[RenanKummer]

The entities Domain, Term, Tag, TermExample and many-to-many associations have been correctly mapped.