I’m Leaving the EF Team, But Still Working on .NET

After 8-and-a-bit years on the Entity Framework team, it is time for something new. I’m staying at Microsoft and will still be working on .NET.

Advertisements

EF Core 1.1: Run Reverse Engineer from Code

EF Core includes the ability to reverse engineer a model from an existing database - using the Scaffold-DbContext command in Visual Studio, or the dotnet ef dbcontext scaffold command for .NET CLI. For an introduction, see Getting Started with an Existing Database. The Problem The commands mentioned above are designed to be invoked on a … Continue reading EF Core 1.1: Run Reverse Engineer from Code

EF6.x Correlating Poor Performing SQL to Application Code

When using an O/RM, poor performing SQL statements are often not discovered until you (or your DBA) find that a particular query is slowing down your database server. At this point, it becomes hard to identify which piece of application code is causing that SQL to be executed.   An interceptor to log slow/failed SQL … Continue reading EF6.x Correlating Poor Performing SQL to Application Code

EF6.1–Workaround Trailing Blanks Issue in String Joins

A semi-common issue that folks hit with Entity Framework is that the in-memory semantics for “relationship fixup” are different than how SQL Server performs joins with regard to trailing spaces in strings. Relationship fixup is the process where EF looks at primary and foreign key values and populates navigation properties when they match.   The … Continue reading EF6.1–Workaround Trailing Blanks Issue in String Joins