将65535行插入SQLServer2008-Insert65535rowsintoSQLServer2008

3  

65K rows is not that many really, but I suggest using System.Data.SqlClient.SqlBulkCopy because it's fast now, and also fast later when your requirements expand. It's also handy to keep an implementation of it around - this sort of thing seems to come up fairly regularly.

65K行确实不是那么多,但我建议使用System.Data.SqlClient.SqlBulkCopy,因为它现在很快,并且在你的需求扩展后也会很快。保持它的实现也很方便 - 这种事情似乎经常出现。

I have an answer to another SO question that has psuedocode describing how I used SqlBulkCopy in my last big project:
Sql server 2008 - performance tuning features for insert large amount of data

我有另一个SO问题的答案,其中psuedocode描述了我在上一个大项目中如何使用SqlBulkCopy:Sql server 2008 - 用于插入大量数据的性能调整功能

It sounds like you want to do the same sort of thing as I, except reading the data from a CSV rather than another database file. Look into a good CSV parsing library for a performant solution to that part of the problem. Good luck!

听起来你想和我做同样的事情,除了从CSV而不是另一个数据库文件中读取数据。查看一个优秀的CSV解析库,以获得针对该部分问题的高性能解决方案。祝你好运!