Procedure Access Object pattern

[iluwatar]

Description:

Implement the Procedure Access Object (PAO) design pattern in the project. The PAO pattern centralizes the logic to access stored procedures in the database, providing a uniform interface for executing these procedures. This helps in decoupling the business logic from the data access logic, promoting a cleaner and more modular design.

Main elements of the Procedure Access Object pattern:

• Centralized Procedure Access: All stored procedure calls are centralized in a single class or a set of classes.
• Uniform Interface: Provides a consistent interface for executing stored procedures, making it easier to manage and call these procedures from different parts of the application.
• Decoupling: Separates the business logic from the data access logic, ensuring a more modular and maintainable codebase.

References:

• Procedure Access Object Design Pattern
• Project Contribution Guidelines

Acceptance Criteria:

1. Implement a class or set of classes to centralize stored procedure calls, ensuring they follow the PAO pattern.
2. Provide a consistent and uniform interface for executing stored procedures.
3. Ensure the new PAO classes are well-documented and include examples demonstrating their use in the project.