- 8/4/2025
- 4 minute read
Disabling thread safety check in Entity Framework
In this blog post we will have a look into how to disable the thread safety check in Entity Framework. What are the implications of doing so and how to do it.
All posts with Tag EF
- 7/7/2025
- 3 minute read
ToListAsync is fast again in Entity Framework (kind of)
Last year I wrote an article about how ToListAsync was slow in Entity Framework titled: "Be careful with ToListAsync and ToArrayAsync in Entity Framework Core". Things have evolved since then, so let's celebrate!
- 3/24/2025
- 4 minute read
Solving Problems you wouldn't have if you wouldn't use Entity Framework
Long title - short intro? Well - I recently came across my own stupidity and wanted to display that to the world. Basically, how to dynamically selecting a column with Entity Framework.
- 12/9/2024
- 2 minute read
LINQ might get a "left join" operator in .net 10
LINQ has a Join operator, that basically translates to something like a SQL INNER JOIN. There is no built in operator for a LEFT JOIN in LINQ, but you can achieve the same result by using a combination of GroupJoin, SelectMany and DefaultIfEmpty. But there is a chance that this might change in the future, as there is a proposal to add a LeftJoin operator in .net 10.
- 11/4/2024
- 4 minute read
Be careful with ToListAsync and ToArrayAsync in Entity Framework Core
Entity Framework has two methods for converting a query to a list or an array: ToListAsync and ToArrayAsync. Of course there is also the sync version of these methods: ToList and ToArray. And sometimes, you should use the latter one!
- 10/28/2024
- 5 minute read
ToArray(Async) vs ToList(Async) in Entity Framework 8
When retrieving data from your database with Entity Framework, there are two major options: ToArray and ToList. Besides the different return type, is there any significant difference in performance between the two? Let's find out!
- 9/9/2024
- 2 minute read
LINQ Joins on multiple columns in Entity Framework
I came across a very annoying "issue" with LINQ joins (left joins) in Entity Framework where the compiler drove me nuts!
- 8/26/2024
- 3 minute read
To Soft Delete or Not to Soft Delete
In this blog post I will discuss the pros and cons of soft deleting records in a database versus other approaches you can take. Heat up your pop corn and get your salt ready!
- 6/17/2024
- 3 minute read
Are my EF LINQ to SQL queries safe?
Have you ever asked yourself if your EF LINQ queries are susceptible to SQL injection attacks? Either because you are querying some user data from a text field or directly taking whatever your API hits against the database?
- 12/14/2023
- 2 minute read
Entity Framework - Storing complex objects as JSON
From time to time, it is nice to store complex objects or lists as JSON in the database. With Entity Framework 8, this is now easily possible. But this was possible all along with Entity Framework 7.
- 1/11/2023
- 5 minute read
Easy Pagination for Entity Framework in 3 steps
Pagination is the process of dividing a set into discrete pages. In the context of Entity Framework, that means we are only getting a certain amount of entries from the database.
And we will implement a very easy solution to make that happen in 3 steps. The result will look like this:
var pagedList = DbContext.BlogPosts.ToPagedList(page: 1, pageSize: 5);
- 12/10/2022
- 1 minute read
Delete a record without prior loading in Entity Framework
Sometimes you have an Id of an object and want to delete the underlying thing from the database. But it doesn't make sense to load the whole object from the database to memory first. So how can we achieve this quickly?
- 11/2/2022
- 5 minute read
Infographics Compendium III - Exceptions, EF Sanitized, Operators, ...
This edition has the following infographics:
DebuggerDisplayAttribute- Entity Framework input and LINQ - is it safe?
ExceptionDispatchInfoimplicitandexplicitoperator