title: How to insert a list of objects into DB with dapper
body: <p>I am making a website based on a Sql Server DB which is still in using by another application. The website is using a MySQL DB since is a SSH website. So I created a a new MySQL database for it and migrated all the data from Sql Server  to MySQL . 
  Since the Sql Server  DB is still in use, it is updating everyday. I can't do the migration job everyday. So I am gonna make a program that read in tables (only 3 tables in the DB is used for the website.But each table has more than 3000 records) from Sql Server  DB and insert those tables into MySQL database. I am using Dapper for the program. I can read out the tables as lists e.g. List. Just wondering is there a good way to insert these lists into MySQL DB. I am using a for loop to insert the lists into DB now. Is there a better way? Thaks.  </p>