For reading queries, if you use other ORM like Dapper, you will gain at least 2x performance difference versus EF Core. If you want to push the limits, you will go with a full raw SQL query. In my personal opinion. You should not benchmark ORM's with raw SQL queries because of its performance differences. Don't compare beans with apples and vice versa.
Thanks for this informative comparison. What about the difference in bench mark between .net and python (gjango/fastapi)
Thank you for your comment :)
I already thought about comparing asp.net core with python, maybe I will make a video about this
Thank u
You pick EF Core versus raw SQL... That's not comparable.
For reading queries, if you use other ORM like Dapper, you will gain at least 2x performance difference versus EF Core. If you want to push the limits, you will go with a full raw SQL query. In my personal opinion. You should not benchmark ORM's with raw SQL queries because of its performance differences. Don't compare beans with apples and vice versa.