This project explores Entity Framework, a modern Object-Relational Mapping (ORM) tool designed for .NET. It showcases the creation of a PostgreSQL database using a Docker container, connection to the database, creation of models using Fluent API, implementation of CRUD operations, and real-time verification of database changes.
- Creation of a PostgreSQL database using a Docker container.
- Connection to the database using Entity Framework.
- Model creation using Fluent API.
- Use of migrations to add seed data to the project.
- Implementation of CRUD operations using Entity Framework.
- Data manipulation in the PostgreSQL test database.
- Validation of results using Postman.
- Real-time verification of database changes using DBeaver.
- .NET Framework
- Entity Framework
- Docker
- PostgreSQL
- Postman
- DBeaver
Clone the repository and open the solution file in Visual Studio. Start a PostgreSQL database using a Docker container. Run the migrations to setup the database and seed data. Use the CRUD operations to add, select, modify and delete data in the PostgreSQL test database. Validate the results using Postman. Monitor the real-time changes to the database using DBeaver.