Introduction A few days ago, one of our clients' accounting officials uploaded an Excel file with student bills and payments — a routine task, done every semester. Except this time, it wasn't routine. The validation API took almost 2 minutes just to process 200 rows, checking each one for dupli...
Source: [Dev.to](https://dev.to/shahriarkabir44/optimizing-aspnet-ef6-for-bulk-insertion-and-massive-data-selection-a-practical-guide-3i5i)