H
Hakan Eren
Hi all,
What is the fastest way to insert data using ADO.Net?
I have to insert more than 500.000 records and calling
xCommand.ExecuteNonQuery is no good.
I also tried filling a data table first and then updating
it.
SQL Server's Bulk insert operation is even more than good
bu it reads from a text file only and also we plan to use
both sqlsrv and oracle, so I can't use dts too.
I have to find a portable programmatic way.
thanx
What is the fastest way to insert data using ADO.Net?
I have to insert more than 500.000 records and calling
xCommand.ExecuteNonQuery is no good.
I also tried filling a data table first and then updating
it.
SQL Server's Bulk insert operation is even more than good
bu it reads from a text file only and also we plan to use
both sqlsrv and oracle, so I can't use dts too.
I have to find a portable programmatic way.
thanx