Relationships in a database context define how two entities relate to each other. Entity Framework Core really shines in supporting relationships. It offers a convention-based configuration, that will configure relationships based on the model provided. For more advanced cases we can use robust Fluent API capabilities, that offer greater flexibility. I must admit that working… Continue reading How to configure relationships in Entity Framework Core 5
Read request headers as an object in ASP.Net Core
Reading headers is a standard operation in ASP.NET Core and has been around for ages. I even wrote a post summarizing all methods of passing parameters: ASP.NET Core in .NET 5 – pass parameters to actions. ASP.NET Core introduced handy attributes to handle parameters in controller methods, like [FromQuery] or [FromHeader]. But is there a way… Continue reading Read request headers as an object in ASP.Net Core
How not to pass parameters in Entity Framework Core 5
Recently I wrote a post about executing raw SQL scripts in Entity Framework Core 5: Executing raw SQL with Entity Framework Core 5. One of the readers noticed that I did a big mistake when passing parameters. Let’s take a closed look. I had code like this:
|
1 2 3 4 5 6 7 8 |
[HttpPost("UpdateProfiles")] public async Task<IActionResult> UpdateProfiles([FromBody] int minimalProfileId = 0) { await primeDbContext.Database.ExecuteSqlRawAsync( $"UPDATE Profiles SET Country = 'Poland' WHERE LEFT(TelNo, 2) = '48' AND Id > {minimalProfileId}"); return Ok(); } |
This method updates profiles Country to Poland, where… Continue reading How not to pass parameters in Entity Framework Core 5
Executing raw SQL with Entity Framework Core 5
Entity Framework Core 5 is an open-source, lightweight, extensible, and a cross-platform ORM. It is easy to apply and it makes database access super simple. However, sometimes working with tables and views is just not enough. How to execute raw SQL script with Entity Framework Core 5? Let’s find out. Running the raw SQL Running… Continue reading Executing raw SQL with Entity Framework Core 5
Working with views in Entity Framework Core 5
In SQL, a view is a virtual table based on the result-set of an SQL statement. They are typically used as read-only objects that are optimized to provide data for a given scenario. Entity Framework Core 5 can handle views and in this article, I’m going to show you how. Adding a view First of… Continue reading Working with views in Entity Framework Core 5
Select data with 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 that returns data in Entity Framework Core 5? In my last post: Execute a stored procedure with Entity Framework Core 5 I showed how… Continue reading Select data with a stored procedure with Entity Framework Core 5
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
How to create a NuGet package targeting multiple frameworks
Working with .NET Standard is a pleasure. It’s fun, it’s short, it’s amazingly readable and concise. As a developer, I would like to work only with .NET Core or .NET Standard code. However, sometimes you need to support the old .Net Framework as well. How to create a NuGet package, that can be used by… Continue reading How to create a NuGet package targeting multiple frameworks
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