SQL Server, MySQL bulk operations plugin

Sql server:

1, Entityframework.bulkinsert. Applies only to SQL Server. To achieve the MySQL batch insert, you have to implement some methods, such as registration driver, temporarily not capable.

2, Z.entityframwork.extensions. Applies to multiple-clock databases, including MySQL and SQL Server. However, it is free of charge and only for the month. A free version is released every month, so you can update the version every month to use it for free. Say there's a free version, and then look for it.

Mysql:

1. Generate SQL statement Bulk INSERT, similar to:

INSERT INTO User (Fn, Ln) VALUES (@Fn1, @Ln1), (@Fn2, @Ln2)...

。 Refer to this article

2, Mysqlbulkloader class. Refer to this article, or this article.

Note: With the CSV test, the test found that the number of fields in the CSV file must be the same as the database fields, in the same order as the number. This method is a field that is sequentially inserted into the database.

3, IBID. SQL Server 2. http://bulk-operations.net/

SQL Server, MySQL bulk operations plugin