I mean, you're definitely still writing a query in this case, just using a lazy-loading C# interface.
An ORM in the traditional sense abstracts the details of the query itself fully away in favor of an object-oriented interface.
EF Core does not lazy load by default. You have to explicitly include relations if you want them on an entity. You can enable lazy loading, but in the default configuration you usually don't have the N+1 problem.
EF Core does not lazy load by default. You have to explicitly include relations if you want them on an entity. You can enable lazy loading, but in the default configuration you usually don't have the N+1 problem.