Insert 2 million rows into SQL Server quickly

You can try this method and it will significantly reduce the database insert execution time.

List<string> toinsert =newList<string>(); StringBuilder insertCmd =newStringBuilder("INSERT INTO tabblename (col1, col2, col3) VALUES ");foreach(varrowinrows) {// the point here is to keep values quoted and avoid SQL injectionvarfirst = row.First.Replace("'","''")varsecond = row.Second.Replace("'","''")varthird = row.Third.Replace("'","''") toinsert.Add(string.Format("( '{0}', '{1}', '{2}' )", first, second, third)); }if(toinsert.Count !=0) { insertCmd.Append(string.Join(",", toinsert)); insertCmd.Append(";"); }using(MySqlCommand myCmd =newMySqlCommand(insertCmd.ToString(), SQLconnectionObject)) { myCmd.CommandType = CommandType.Text; myCmd.ExecuteNonQuery(); }

*Create the SQL connection object and replace it where I have written the SQLconnectionObject.