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 cause of the issue is described here: https://github.com/dotnet/efcore/issu...
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.
On this page of the site you can watch the video online Entity Framework/EFCore Returns Wrong Data (When Using FromSqlRaw) with a duration of hours minute second in good quality, which was uploaded by the user Coding With Brett 11 April 2022, share the link with friends and acquaintances, this video has already been watched 834 times on youtube and it was liked by 8 viewers. Enjoy your viewing!
