哪个更好:DataSet 还是 DataReader?

What#39;s better: DataSet or DataReader?(哪个更好:DataSet 还是 DataReader?)
本文介绍了哪个更好:DataSet 还是 DataReader?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我刚刚看到了这个话题:Datatable vs Dataset但这并没有解决我的疑问.. 让我更好地解释一下,我正在与数据库进行连接,需要在 GridView 中显示结果.(我之前在使用 VB6 时使用了 RecordSet,DataSet 与它非常相似,因此使用 DataSet 更容易.)然后一个人告诉我 DataSet 不是最好的方法..

I just saw this topic: Datatable vs Dataset but it didn't solve my doubt .. Let me explain better, I was doing connection with database and needed to show the results in a GridView. (I used RecordSet when I worked with VB6 while ago and DataSet is pretty similar to it so was much easier to use DataSet.) Then a guy told me DataSet wasn't the best method to do ..

那么,我应该学习" DataReader 还是继续使用 DataSet ?数据表?有什么优点/缺点?

So, should I 'learn' DataReader or keep using DataSet ? DataTable ? What are the pros/cons ?

推荐答案

本质上就是:桶还是软管哪个更好?"

That is essentially: "which is better: a bucket or a hose?"

一个DataSet就是这里的桶;它允许您携带一组断开连接的数据并使用它 - 但您将承担携带存储桶的成本(因此最好将其保持在您喜欢的大小).

A DataSet is the bucket here; it allows you to carry around a disconnected set of data and work with it - but you will incur the cost of carrying the bucket (so best to keep it to a size you are comfortable with).

数据阅读器是软管:它提供单向/一次性访问数据,因为它飞过您;您不必一次携带所有可用的水,但需要将其连接到水龙头/数据库.

A data-reader is the hose: it provides one-way/once-only access to data as it flies past you; you don't have to carry all of the available water at once, but it needs to be connected to the tap/database.

就像你可以用软管填充桶一样,你可以用数据读取器填充 DataSet.

And in the same way that you can fill a bucket with a hose, you can fill the DataSet with the data-reader.

我想说的是,他们做不同的事情......

The point I'm trying to make is that they do different things...

我个人并不经常使用 DataSet - 但有些人喜欢它们.但是,我确实使用数据读取器进行 BLOB 访问等.

I don't personally use DataSet very often - but some people love them. I do, however, make use of data-readers for BLOB access etc.

这篇关于哪个更好:DataSet 还是 DataReader?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

DispatcherQueue null when trying to update Ui property in ViewModel(尝试更新ViewModel中的Ui属性时DispatcherQueue为空)
Drawing over all windows on multiple monitors(在多个监视器上绘制所有窗口)
Programmatically show the desktop(以编程方式显示桌面)
c# Generic Setlt;Tgt; implementation to access objects by type(按类型访问对象的C#泛型集实现)
InvalidOperationException When using Context Injection in ASP.Net Core(在ASP.NET核心中使用上下文注入时发生InvalidOperationException)
LINQ many-to-many relationship, how to write a correct WHERE clause?(LINQ多对多关系,如何写一个正确的WHERE子句?)