1. Asynchronous query error:

return dc.table.ToListAsync();

Error: The source IQueryable doesn’t implement IDbAsyncEnumerable<xxx>…..

2. Solve:

It is found that the project references both Entityframework and Microsoft.EntityFrameworkCore, which can be solved by removing the Entityframework package.

 

F12 enters the ToListAsync method (before removing the Entityframework package)

 

After removal

 

It can be seen that different assemblies are used.