Quote:
How to transfer SQL data from one table to another using entity framework core
Wrong approach!
What you describe is:
Read table 1 from SQL server => Send data to PC => Send data back to SQL server => Write data to table 2 on SQL server.
when it can be simplified to:
Read table 1 from SQL server =>
Send data to PC => Send data back to SQL server => Write data to table 2 on SQL server.
and:
Read table 1 from SQL server => Write data to table 2 on SQL server.
You have to write 1 SQL request!
Advantage, it is faster.