Execute a stored procedure with Entity Framework Core 5

Stored procedures are an integral part of any MS SQL database. They are perfect to wrap complicated SQL into a database object, that we can reuse. How to execute a stored procedure in Entity Framework Core 5? Let’s have a look. Adding a stored procedure First of all we need to add a stored procedure.… Continue reading Execute a stored procedure with Entity Framework Core 5

Merging migrations in Entity Framework Core 5

When working with a fast-evolving project changes happen rapidly not only to the project’s code but also to the database schema. It happens especially when working on a micro-service from the start when its purpose shifts. How EF Core 5 migrations work In Entity Framework Core 5 migrations we are adding a migration as a… Continue reading Merging migrations in Entity Framework Core 5

Adding Entity Framework Core 5 migrations to .NET 5 project

Database migrations help a developer to keep database schema up-to-date with the code. It is a core mechanism, that keeps changes in code and applies them in the database. Entity Framework Core 5 migrations are designed to keep track of DbContext class and generate migrations when you update it. Installing the tools To add EF… Continue reading Adding Entity Framework Core 5 migrations to .NET 5 project

Adding an Entity Framework Core 5 to an existing database

Entity Framework Core 5 is a light and easy to use ORM, that let you use the database without writing any SQL commands. Built-in mechanisms will translate your LINQ queries on your entity classes to SQL queries and return mapped objects. Here is an article about adding EF Core with migrations to an empty database: PrimeHotel… Continue reading Adding an Entity Framework Core 5 to an existing database

PrimeHotel – passing parameters to actions – assignments

This is a post with assignments to do if you would like to check your knowledge about ASP.NET Core in .NET 5. This one is about passing parameters to controller actions, which is a crucial thing to master when developing micro-services. You don’t need to start from scratch, you can base on a PrimeHotel project,… Continue reading PrimeHotel – passing parameters to actions – assignments