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
Category: ASP.NET Core for .NET 5 & EF Core 5
All posts about ASP.NET for .NET 5 and 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 – adding Entity Framework Core 5 in .NET
Let’s have a look at how to introduce Entity Framework Core 5 in ASP.NET Core project in .NET 5. We will start from an empty database, where we have a clean slate and can add tables the way we want. In this post we will work with the PrimeHotel project, that was created for learning… Continue reading PrimeHotel – adding Entity Framework Core 5 in .NET
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
PrimeHotel – how to run this project
In this post, I will guide you through the process of downloading and running my project – PrimeHotel. It is a project created for learning purposes so you are free to contribute, clone, and use it for any non-commercial activity. It is a medium-sized service, that represents a hotel management system. Is holds user reservations,… Continue reading PrimeHotel – how to run this project
.NET 5 – How to start
Would you like to learn how to write programs in .NET and find out what the platform from Microsoft can do? What tools to use and where to start? You’ve come to the right place! I will explain everything step by step. What is .NET? .NET is a programming platform created by Microsoft. Here are… Continue reading .NET 5 – How to start
ASP.NET Core in .NET 5 – sending a request
Sending a request in ASP.NET Core in .NET 5 is a standard operation that can be achieved pretty easily. However, details matter in this case and I’ll show you the best practice available. We will also take a look at some advanced features to get the full scope. Using a real available API In this… Continue reading ASP.NET Core in .NET 5 – sending a request
ASP.NET Core in .NET 5 – pass parameters to actions
Passing parameters to actions is an essential part of building RESTful Web API. ASP.NET Core released as a part of .NET 5 offers multiple ways to pass parameters to methods, that represent your endpoints. Let’s see what they are. Pass parameter as a part of an URL When passing a parameter in a URL, you… Continue reading ASP.NET Core in .NET 5 – pass parameters to actions