none
Ado .net question ? which is the efficient sql data component for retrieving the data? RRS feed

  • General discussion

  •  which is the efficient sql data component for retrieving the data?

    1)sql data reader     2) sql data adapter 3) sql data provider


    mohammed

    • Moved by Vicky SongMicrosoft employee Thursday, July 26, 2012 7:30 AM (From:Visual Studio Database Development Tools (Formerly "Database Edition Forum"))
    Wednesday, July 25, 2012 10:41 AM

All replies

  • I think the ADO.NET Managed Providers forum (http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders) is better for this question.

    I can't speak to the SqlDataProvider but a SqlDataReader is the most direct way to retrieve data using managed code.  SqlDataAdapter uses SqlDataReader to retrieve data and provides much additional functionality for working with data on the client side and persisting database changes.


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/

    Wednesday, July 25, 2012 10:59 AM