// archive
Tag: .Net
-
Common Entity Framework Problems: N + 1
I wanna dance with common problems One of the most common issues that I’ve seen with Entity Framework isn’t technically an Entity Framework problem at all. The N + 1 problem is an anti-pattern that is a problem with ORMs in general, which most often occurs with lazy loading. There was a lot going on…
-
The Case of Entity Framework Core’s Odd SQL
Recently, Julie Lerman contacted me about some strange SQL that Entity Framework Core (EF Core) was generating. Now, EF Core is fairly new and works with Microsoft’s newest framework .NET Core. I haven’t had a chance to get my hands on EF Core yet so I was excited to see what it was doing. And of course…
-
How to Select Specific Columns in an Entity Framework Query
One of the most frequent complaints that I hear when presenting to DBAs about Entity Framework is that it’s “slow” and that “developers should be endlessly tortured for using it”. Ok, the second part I just made up but the sentiment exists. DBAs just don’t like developers using Entity Framework and with good reason. Entity Framework can make…
-
Changing T4 Template Background Colors in Visual Studio
T4 is a templating engine inside of Visual Studio that lets you generate, well, text. Since T4 has no editor goodies in Visual Studio the Tangible T4 Editor is a good way to get some of the goodies back. But if you’re using the “dark” theme in Visual Studio the Tangible T4 Editor needs a color change.…
-
Unraveling the mysteries of NewSequentialID
A few months ago we started development on a new system. From the ground up we redesigned everything from our business processes to how we store data. Part of the redesign was deciding on using SOA technology in our middle tier. This will allow us to separate our UI from our middle tier even further.…