Question

I have created a method that can be called using a stored procedure name and list of SqlParameters, lets call it GetData(). GetData() then manages talking to the SQL Server and getting the data. What I then need to do is hand the data back to the caller for them to read, they have no need to manipulate it. What I am trying to figure out is if it is best to hand the caller back a DataTable or SqlDataReader?

我现在想到的是,掌握数据是最佳途径。我就此决定:

The sets of data I am getting back are small, under 100 rows and 20 columns, so memory shouldn t be an issue.
From what I understand, a DataTable grabs all of the data and plugs it into the DataTable, then disconnects itself so GetData() would manage it s own connection.
With a SqlDataReader, I would have to manage the connection in the calling function after I am done with the data. I would not be able to close it after I have made the call in GetData() since I am only reading one row at a time from the database.

这似乎好像是满足我需要的最佳途径吗?

Answer 1

Yes, your idea is good.

通过数据表,而不是数据校对。链接仅应维持在最低水平上,向数据库服务器传输数据所需的时间。

Answer 2

Use a DataTable. The data bound controls are built to use that abstraction.

友情链接