A great talk can seem very natural and off-the-cuff when seated in the audience. But, behind the scenes, most speakers put a lot of effort into preparing a talk. Preparation is everything, especially for those of us that aren’t natural public speakers.
Giving a Tech Talk – Part 2/3: Build Demos
A great talk can seem very natural and off-the-cuff when seated in the audience. But, behind the scenes, most speakers put a lot of effort into preparing a talk. Preparation is everything, especially for those of us that aren’t natural public speakers.
Giving a Tech Talk – Part 1/3: Create a Story
A great talk can seem very natural and off-the-cuff when seated in the audience. But, behind the scenes, most speakers put a lot of effort into preparing a talk. Preparation is everything, especially for those of us that aren’t natural public speakers.
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.
EF Core 1.1: Read Only Entities & Extending Metadata with Annotations
EF Core has a well defined set of concepts that can be configured for entity types and properties. Examples include the primary key of an entity, whether a property is required or optional, etc. Aside from these "baked in" concepts, there are metadata annotations that allow additional concepts to be added to the model. For example, the … Continue reading EF Core 1.1: Read Only Entities & Extending Metadata with Annotations
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
EF Core 1.1 Pluralization in Reverse Engineer
EF Core - Learn how to extend the reverse engineer services to perform pluralization and singularization when reverse engineering a model from an existing database.
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 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.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
EF6.1 Getting Key Properties for an Entity
Today I had a question show up in my inbox about finding the key properties of a given entity type. Searching around I didn’t find a good existing post about this, so here is the code you need. The code provides a couple of simple extension methods to DbContext. Note that the code is somewhat … Continue reading EF6.1 Getting Key Properties for an Entity
Reducing Code First Database Chatter
Code First has automatic functionality built in to help you get up and running with a database and warn you when you may have made a mistake that will cause your app to fail. This is generally helpful when you are developing an application – especially when you are new to EF – but when … Continue reading Reducing Code First Database Chatter
EF6.1 Mapping Between Types & Tables
A while back I blogged about how to find what table(s) a given entity is mapped to. The solution in that post worked around the fact that the API for accessing this information was internal. In EF6.1 we made the mapping API public, so it’s now a lot easier. The other advantage of this code … Continue reading EF6.1 Mapping Between Types & Tables
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
EF Code First Mapping Between Types & Tables
Starting in EF6.1 there is an easier way to do this. See my new EF6.1 Mapping Between Types & Tables post for details. Entity Framework includes the MetadataWorkspace which gives you access to the metadata EF keeps about the shape of your model. The problem is that the Mapping section of this – the bit … Continue reading EF Code First Mapping Between Types & Tables
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
How to Drop a Database from Visual Studio 2012
Seems like it should be easy right? It depends which SKU of Visual Studio you have… Option 1: SQL Server Object Explorer If you have a SKU of Visual Studio that includes SQL Server Object Explorer (SSOE) then it’s pretty easy. You’ve probably only got this if you parted with some hard earned cash … Continue reading How to Drop a Database from Visual Studio 2012