Entity Framework Core is recommended and the most popular tool for interacting with relational databases on ASP NET Core. It is powerful enough to cover most possible scenarios, but like any other tool, it has its limitations. In earlier versions of EF developers could know that request is executing on client side only from EF logs.
Table of contents
Entity Framework Core and high performanceIntroduction to EFSystem Under Test (SUT)DbContext poolingDisable change tracking for read-only scenariosUsing DbContext.Entry for editingLINQ to SQL pre-compilationDisable internal concurrency checksCombining improvementsSummarySort: