.NET数据表到一个临时SQL表 [英] .NET datatable to a temporary SQL table

问题描述

什么是fastet和最有效的方式把一个数据表在.NET到一个临时SQL表上的远程的SQL Server instace <？ / P>

我的工作就可以包含多达10万条记录的数据表，所以我很关心性能。

解决方案

10万的记录，并且您comcerned性能如何？是服务器手机？ 100万条记录是小，亿开始是想和你有问题的水平，100.00的记录是值得我片能有效地处理。

只要做到这一点。 SqlBulkCopy的是从.NET应用程序将数据移动到服务器的最快方法并没有很多可以使用，经过了优化。我会定期上传的记录数以百万计（上千万）这样做，我的网格做财务的模拟。

What would be the fastet and most efficient way to put a DataTable in .NET into a temporary SQL table on a remote SQL Server instace?

The datatables I am working on can contain up to 100,000 records, so I am concerned about performance.

解决方案

100k records and you are comcerned about performance? Is the server a mobile phone? 1 million records is SMALL, 100 million starts to be "think or you have a problem" level, 100.00 records is something my tablet can efficiently deal with.

Just do it. SqlBulkCopy is the fastest way to move data from a .NET application down to a server and there is not a lot you CAN optimize anymore after using that. I regularly upload millions (tens of millions) of records doing that my grid does financial simulations.

这篇关于.NET数据表到一个临时SQL表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！