- 09/09/2024
- 2 min
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!
All posts with Tag EF
- 26/08/2024
- 3 min
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!
- 17/06/2024
- 3 min
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?
- 14/12/2023
- 2 min
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.
- 11/01/2023
- 5 min
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);
- 10/12/2022
- 1 min
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?
- 02/11/2022
- 5 min
Infographics Compendium III - Exceptions, EF Sanitized, Operators, ...
This edition has the following infographics:
DebuggerDisplayAttribute- Entity Framework input and LINQ - is it safe?
ExceptionDispatchInfoimplicitandexplicitoperator