We will create our Database with the help of the Entity Framework Core (also known as EF Core), the well-known open source Object Relational Mapper (ORM) for ADO.NET developed by Microsoft. The reasons for such a choice are many:
- Seamless integration with the Visual Studio IDE
- A conceptual model based upon entity classes (Entity Data Model or EDM) that will enable us to work with data using domain-specific objects without the need to write data-access code, which is precisely what we’re looking for
- Easy to deploy, use, and maintain in development and production phases
- Compatible with all the major open source and commercial SQL-based engines, including MSSql, MySql, PostgreSql, Oracle, and more, thanks to ...