Tech Off Thread

4 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

SqlConnection or TableAdapters

Back to Forum: Tech Off
  • User profile image
    Zerolux

    Is it any benefits to use DataSet-things in VS? Or do you gain performance by doing your SQL-queries by hand?

  • User profile image
    Maddus Mattus

    TableAdapters use SqlConnection,...

    So no there is no performance penalty,...

    If it suits your requirements, use it! Better then writing the code yourself,...

  • User profile image
    JChung2006

    To say there is no performance penalty is untrue.  TableAdapters do several things above and beyond what using barebones ADO.NET code would do.  That said, there are productivity and feature benefits to using TableAdapters that may outweigh the performance disadvantages.

  • User profile image
    Maddus Mattus

    Code that you should otherwise write yourself,...

    Sure there is a performance hit, but it is so small you can take it out of the equasion.

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.