Entity Framework is a powerful ORM tool which makes storage/retrieval of data simple. Although it's simple to get going, there are a few gotchas that can cripple your app performance. Here's my top 5 list of mistakes to look out for: … [Read more...]
7 Ways to Increase the Performance of Entity Framework
My first project that used Entity Framework was a disaster. It was a web application that was so slow; you could make a cup of tea, drink it, wash up, and the home page would still be loading. Was it Entity Framework that was slow? ŠOr was it my mistake? … [Read more...]
How to Increase the Performance of Entity Framework with Paging
Paging increases performance by reducing the amount of records returned by SQL queries. Combine paging with Entity Framework projection queries, and you'll notice a major increase in performance. In this post, you will learn how to implement paging with Entity Framework. … [Read more...]
Increasing the Performance of Entity Framework with Projection Queries
If you're not using Entity Framework projection queries, your application is certain to run like a big fat slimy slug! In this post, we will look at what projection queries are, how to write them, and when you should use them. … [Read more...]
How to Store Application Settings in ASP.NET MVC Using Entity Framework
In this tutorial, we will create a strongly typed Settings API that uses Lazy loading, Cache, Reflection and Entity Framework to manage application settings in ASP.NET MVC. I will explain why its better to store settings in a database, how using reflection can make it easier to add new settings, and how to group the settings into a wrapper that uses Lazy loading and cache. … [Read more...]