Entity Framework/EFCore Returns Wrong Data (When Using FromSqlRaw)

Publié le: 11 avril 2022
sur la chaîne: Coding With Brett

834

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.

Sur cette page du site, vous pouvez voir la vidéo en ligne Entity Framework/EFCore Returns Wrong Data (When Using FromSqlRaw) durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Coding With Brett 11 avril 2022, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 834 fois et il a aimé 8 téléspectateurs. Bon visionnage!

181