SqlDataAdapter vs SqlDataReader for DBAs
2
votes
2
answers
1493
views
Speaking to developers about the use of
vs
and reading this: https://stackoverflow.com/questions/1676753/sqldataadapter-vs-sqldatareader
Yields little in the way of explaining the effect on SQL Server of switching from
to
.
I understand
potentially increases the length of time a connection is open to SQL Server, and that certainly is a concern when it comes to efficient use of pooled connections.
Aside from this, what is the effect on SQL Server of using
instead of
? Has anyone observed the effect of this change on SQL Server?
Asked by Peter
(1500 rep)
Jul 12, 2018, 01:22 PM
Last activity: Jul 12, 2018, 05:44 PM
Last activity: Jul 12, 2018, 05:44 PM