Consider implementing a generic Repository pattern

[nanotaboada]

Description

While EF Core’s DbContext provides some Repository-like features:

A DbContext instance represents a session with the database and can be used to query and save instances of your entities.
DbContext is a combination of the Unit Of Work and Repository patterns.

Consider implementing a more explicit generic Repository pattern to standardize data access and make the codebase more flexible for future changes.

Acceptance Criteria

• Implement a generic repository for common CRUD operations.
• Refactor existing Service layer to use the Repository pattern.
• Write tests to verify Repository functionality.

Resources

• 🔗 EF Core DbContext Documentation
• 🔗 Repository Pattern in ASP.NET Core