问题描述
我刚刚看到了这个话题: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?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!