I have a DataTable
that I want to push to the DB. I want to be able to say like
myDataTable.update();
But after reading the MSDN docs, apparently this does inserts row by row.
It should be noted that these statements are not performed as a batch process; each row is updated individually.
What are my alternatives?
Edit: I am using SQL Server 2005