Sample Header Ad - 728x90

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