Post History

What you want would be called `DbSet<>.Find()` combined with eager loading of the related entities. According to [the docs](https://learn.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.dbset-1.find?view=efcore-7.0), eager loading is not mentioned and its sole purpose is to easily get an entity based on its type and keys:

 > Finds an entity with the given primary key values. If an entity with the given primary key values is being tracked by the context, then it is returned immediately without making a request to the database. Otherwise, a query is made to the database for an entity with the given primary key values and this entity, if found, is attached to the context and returned. If no entity is found, then null is returned.

In order to get an entity and its related entities, you can rely on a LINQ filter function + Include:

```c#
var blog = db.Blogs
    .Include(b => b.Posts)
    .FirstOrDefault(b => b.Id == id);
```

This will generate a query to fetch data for both the blog with and its associated posts (eager loading of the posts).

Note: For scenarios where performance is important, you can only fetch the required columns. Example:

```c#
var blogInfo = db.Blogs
    .Select(b => new 
         { 
              BlogId = b.BlogId, // explicit property name
              BlogUrl = b.Url,
              PostData = b.Posts.Select(p => new { p.Id, p.Title })
         }
    .FirstOrDefault(b => b.BlogId == id);
```

Of course, a DTO can be used instead of anonymous types. The interesting part is that EF Core (5+) figures out automatically that Posts columns are required and no explicit `Include()` is required.