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.
En esta página del sitio puede ver el video en línea Entity Framework/EFCore Returns Wrong Data (When Using FromSqlRaw) de Duración hora minuto segunda en buena calidad , que subió el usuario Coding With Brett 11 abril 2022, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 834 veces y le gustó 8 a los espectadores. Disfruta viendo!
