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