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
EF6.1 Get Mapping Between Properties and Columns
One of the most popular posts on my blog has been EF6.1 Mapping Between Types & Tables. Someone asked me this week about getting the property/column mapping in addition to the type/table mapping. There isn’t a whole lot to say (other than the code is horrible and this will look a whole lot better in … Continue reading EF6.1 Get Mapping Between Properties and Columns
EF6/6.1 Level 300-400 Talk-in-a-Box
I recently posted an EF6 Level 100-200 Talk-in-a-Box to make it easier for folks to present EF6 to their user group, local conference, work colleagues, or anyone who would listen. I also recently put together a more in-depth talk on EF for Building Modern Web Apps day of Azure Week. I just tidied up the … Continue reading EF6/6.1 Level 300-400 Talk-in-a-Box
EF6 Level 100-200 Talk-in-a-Box
Putting a good technical talk together takes a decent amount of work. You need to make sure your talk tells a story from end-to-end, you need to give folks enough context (without spending the whole talk in PowerPoint), and you need clear concise demos that folks can follow. You also have to make sure your … Continue reading EF6 Level 100-200 Talk-in-a-Box
EF5 & EF6 on VS Toolbox (Source Code Included)
I recently had the pleasure of appearing on a Visual Studio Toolbox episode, hosted by Robert Green, with my co-worker Glenn Condron. Back in the EF4.3 days I had been part of another 2 part series on VS Toolbox with Diego Vega. Since the previous episodes were so popular we thought we should catch up … Continue reading EF5 & EF6 on VS Toolbox (Source Code Included)
EF6 Suspendable Execution Strategy
EF6 introduces the new connection resiliency feature that allows for automatic retries of failed database operations. I was recently writing some documentation for EF6 and came across a scenario where it would be useful to have a global switch to enable/disable retry logic. Such a switch isn’t built into EF6, although we do have an … Continue reading EF6 Suspendable Execution Strategy
TechEd 2013 Talks & Source Code
Last week I had the pleasure of attending TechEd 2013 to present a couple of sessions. Here are links to the session recordings, slides and source code. Breakout Session: Entity Framework 6: Database Access Anywhere, Easily This session covers the basics of EF6, open source, and a series of demos for the new EF6 … Continue reading TechEd 2013 Talks & Source Code