Analyze adding transaction support to Repository

[nanotaboada]

Description

Add support for transactions in the Repository to ensure data integrity in scenarios where multiple operations need to be executed atomically.

Acceptance Criteria

• Modify the Repository to begin and commit transactions as needed.
• Ensure that changes are rolled back in case of failures.
• Add tests for transactional behavior.
• Document transaction management in the codebase.

Resources

• 🔗 EF Core Transactions