在填充数据表时，datareader是否比数据集快吗？ [英] Is datareader quicker than dataset when populating a datatable?

问题描述

1）循环数据采集器并创建一个基于填充的数据表的自定义行和列。

在动态创建数据表时，datareader的性能仍然保持正确？

解决方案

DataAdapter在引擎盖下使用DataReader，以便您的体验可能会相同。

DataAdapter的好处是删除了大量需要维护的代码。

这场辩论有点像宗教问题肯定环顾四周，决定最适合您的情况：

• http://blogs.msdn.com/memilavi/archive/2008/02/18/datareader -vs-dataset-the-real-question.aspx


• http://xcskiwinn.org/community/blogs/panmanphil/archive/2004/09/21/281.aspx


• http：/ /weblogs.asp.net/joelevi/archive/2 008/02/12 / asp-net-datareader-vs-dataset.aspx


• http://weblogs.asp.net/dreilly/archive/2003/09/27/29411.aspx

Which would be quicker.

1) Looping a datareader and creating a custom rows and columns based populated datatable

2) Or creating a dataAdapter object and just (.Fill)ing a datatable.

Does the performance of a datareader still hold true upon dynamic creation of a datatable?

解决方案

The DataAdapter uses a DataReader under the hood so your experience would likely be the same.

The benefit of the DataAdapter is you cut out a lot of code that would need maintenance.

This debate is a bit of a religious issue so definitely look around and decide what works best for your situation:

• http://blogs.msdn.com/memilavi/archive/2008/02/18/datareader-vs-dataset-the-real-question.aspx
• http://xcskiwinn.org/community/blogs/panmanphil/archive/2004/09/21/281.aspx
• http://weblogs.asp.net/joelevi/archive/2008/02/12/asp-net-datareader-vs-dataset.aspx
• http://weblogs.asp.net/dreilly/archive/2003/09/27/29411.aspx

这篇关于在填充数据表时，datareader是否比数据集快吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！