一次上传30,000行以上的最佳方法. [英] Best Way to Upload More than 30,000 Rows in One Go.

问题描述

请让我知道一次从c#上载sql server 2008数据库中30,000行数据的最佳方法.


等待您的答复.

致谢.

Please let me know the best way to Upload 30,000 rows of data in sql server 2008 database from c# in one go.


Waiting For your Reply.

Thanks & Regards.

推荐答案

使用sql批量复制类.它正是为此目的而设计的.检查有关MSDN的详细信息.

Use the sql bulk copy class. Its designed for exactly this purpose. Check details on MSDN.

检查文章:批量更新表 [ ^ ]

Check artilces: Bulk INSERT / UPDATE / DELETE in LINQ to SQL[^]
If you do as Sandeep suggests, then please:Batch Update on a very huge table[^]

这篇关于一次上传30,000行以上的最佳方法.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！