c# mysql best way to upload a large data table to a mysql db table

c# mysql best way to upload a large data table to a mysql db table

I have a really large table with about a 1,000,000 rows of data in a c#
datatable and I would like to upload that into a mysql db table. What is
the best and fastest way to do this ?
Looping through the rows and uploading one row at a time looks to be the
really bad performance wise and also throws a timeout exception at times.
I know that one of the solutions is to write it out to a file and read it
from file using mysqlbulkloader. Is there any other way this could be done
directly from the data table to the database ?