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

Veröffentlicht am: 11 April 2022
auf dem Kanal: 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.

Auf dieser Seite können Sie das Online-Video Entity Framework/EFCore Returns Wrong Data (When Using FromSqlRaw) mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Coding With Brett 11 April 2022 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 834 Mal angesehen und es wurde von 8 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!