EF Core 3.1 breaks left join with no navigation propertyWhen upgrading from .NET Core 2.2 to 3.1, an invalid LEFT JOIN error was encountered. The issue was resolved by adding Navigation property.John Reilly·Jan 2·2 min readFollowsql server
VSTS and EF Core MigrationsLearn how to migrate Entity Framework database migrations during an ASP.NET Core project deployment with a console app using VSTS and Azure.John Reilly·Jun 24·4 min readFollowazure devopssql server
Integration Tests with SQL Server Database SnapshotsDiscover the benefits of using database snapshots for integration tests to reduce complexity & errors in this informative article.John Reilly·Sep 12·4 min readFollowsql serverautomated testing
Back to the Future with Code First MigrationsCode First Migrations order is determined by file name, not renaming, and requires changing the IMigrationMetadata.Id property to match.John Reilly·Jun 19·3 min readFollowsql server
Integration Testing with Entity Framework and Snapshot BackupsThe article shows how to use SQL Servers snapshot backups for creating effective integration tests that dont affect production data.John Reilly·Jan 24·8 min readFollowsql serverautomated testing
Unit Testing and Entity Framework: The Filth and the FuryControversy arises over Unit Testing with Entity Framework & MOQ. A simple class could be used to wrap all Entity Framework code.John Reilly·Oct 3·8 min readFollowautomated testingsql server
