How to enable split queries globally in Entity Framework

The AsSplitQuery() method in Entity Framework is useful as it allows us to avoid cartesian explosion which can cause performance issues.

Did you know we can also set split queries as the default and then override on a query level if/when desired 👇🏻 …


You might also be interested in...

Using split queries (AsSplitQuery) in Entity Framework Core to avoid the cartesian explosion problem
Without lazy loading in Entity Framework Core we must eagerly load related entities which means we can experience the ‘cartesian … Continue reading Using split queries (AsSplitQuery) in Entity Framework...

How to add SQL query hints to Entity Framework Core queries
I don’t think there’s anything built into Entity Framework for this as query hints can often be very DB platform … Continue reading How to add SQL query hints to...

Using Entity Framework Core Interceptors to log SQL queries
Since version 3 Entity Framework Core has supported Interceptors. The interception API allows developers to easily intercept and examine and … Continue reading Using Entity Framework Core Interceptors to log...

Labelling Entity Framework Core queries in log files using TagWith
In Entity Framework Core (2.2+) if you’re capturing queries in logs consider using the TagWith feature to output an arbitrary … Continue reading Labelling Entity Framework Core queries in log...

String.FirstOrDefault() LINQ queries now supported in Entity Framework Core 5.0
Entity Framework Core 5.0 now supports the translation of String.FirstOrDefault() LINQ queries. In EF Core 3.1 the following would fail… … Continue reading String.FirstOrDefault() LINQ queries now supported in Entity...

Leave a Reply

Your email address will not be published. Required fields are marked *