filmov
tv
Entity Framework/EFCore Returns Wrong Data (When Using FromSqlRaw)
Показать описание
You might find this short video useful if you're using the Entity Framework (EFCore) in .NET Core and you find out it's returning the wrong data.
This can happen for a number of reasons but in my particular case it was when I was using the FromSqlRaw method in C#. It seems particularly common if you're doing table joins (especially INNER JOINs).
To check you have the same problem, simply run the SQL query you're using in the FromSqlRaw method call in SQL Server itself. If the data in SQL Server Management Studio is correct but the wrong data is being returned from the Entity Framework then you have this issue.
The proposed solution is to tack on a call to AsNoTracking(). Just be sure to thoroughly test your code after you do so. This solution worked for me and I was fortunate the C# method with the error was only called once from our application.
Hope you found that useful - subscribe for more C# and SQL tutorials.
This can happen for a number of reasons but in my particular case it was when I was using the FromSqlRaw method in C#. It seems particularly common if you're doing table joins (especially INNER JOINs).
To check you have the same problem, simply run the SQL query you're using in the FromSqlRaw method call in SQL Server itself. If the data in SQL Server Management Studio is correct but the wrong data is being returned from the Entity Framework then you have this issue.
The proposed solution is to tack on a call to AsNoTracking(). Just be sure to thoroughly test your code after you do so. This solution worked for me and I was fortunate the C# method with the error was only called once from our application.
Hope you found that useful - subscribe for more C# and SQL tutorials.
Entity Framework/EFCore Returns Wrong Data (When Using FromSqlRaw)
The Common Entity Framework Mistake You MUST Fix
Don't Make These Entity Framework Core Mistakes
Entity Framework AsNoTracking Does Nothing In This Case #shorts
The Old and New Way To Delete Entities With EF Core #shorts
Stop Dealing with EF Core Exceptions Wrong!
Stop using Entity Framework as a DTO provider!
Common Entity Framework Mistakes
Unlocking the Secrets of Entity Framework Core
Common mistakes in EF Core - Jernej Kavka - NDC Oslo 2023
Making Entity Framework Core As Fast As Dapper
How to Return Non Entities in Entity Framework Core with LINQ and Use Anonymous Types Instead
Getting Started with Entity Framework Core in .NET
DON'T use this EF Core Performance trick #shorts
Entity Framework Community Standup - Typed Exceptions for Entity Framework Core
.NET Data Community Standup - Entity Framework Core FAQs
Get the most out of EF Core by avoiding these common mistakes
EF Core Performance Optimization Challenge | 233x FASTER
How to Update and Delete with Entity Framework Core
Optimize Your EF Core Queries – Here's How
C# : Is instantiating a GUID in Entity Framework Core bad practice?
This SPEED is getting RIDICULOUS! - SQL Queries with Entity Framework Core BulkExtensions
Entity Framework Core Advanced Techniques for Efficient Data Retrieval
Entity Framework Core vs Dapper Performance in 2023
Комментарии