DB Command overload

[alexcastrodev]

Based on BulkController on line 98, the ProcessExcelRow is overloaded:

Scenario:

A user upload a excel file, then, the function will read line by line, check if this line exist, then, will saveChanges.

Why not transaction ?

The Transaction is save all or nothing. If some line has error, i dont want to rollback. I want to save in database all succeed and return a blob of errors.

Possible solutions:

1 - Divide in chunks of inserts, and it will decrease the inserts / select commands
2 - Save the Succeded and call a new transaction to save all of them.

dbContext.ChangeTracker.Entries()
                .Where(e => e.State == EntityState.Added || e.State == EntityState.Modified)
                .Select(e => e.Entity);

3 - First select all stored ids, before perform a Stream.

[alexcastrodev]

I Merged the solution 3, but i will try do something like solution 2 until sunday.

I dont know if i have time for this, since i want to implement redis for request locations.