I’ve mySQL database with a table containing approx 45 columns. I’ve a custom list containing around 20k rows and have to insert these rows with all columns in that mySQL database table using c#.

I’ve to do this on daily basis with approx 18k-20k rows, so I need to schedule this service. Please guide me how I can do that?

Note: I’ve did with MS SQL Server and all are ok , but now we’re moving to MySQL so please help me on it.

using ms sql server, making my own custom list then converting my own custom list into DataTable then bulk importing DataTable logs in batch of 5000 rows.

Now looking for same with mysql database table