Usage of EntityFramework Async Query operations

[sandorfr]

As discussed on twitter, I'm opening this issue about covering the usage of EF Query Async operations.

Is it wise to say that we should always use Async methods for query when it comes to EntityFramework Core (according to the ef core docs I would say it is but since you don't mention it) https://docs.microsoft.com/en-us/ef/core/querying/async

[Siderite]

It's funny that there are some Async methods that are mostly used internally and their description is "use the sync version", like AddAsync