SQL Helper class?

Posted on 2009-02-09
Last Modified: 2012-05-06
Could you tell me what exactly is this SQL Helper class?
Question by:boneythomas
    LVL 11

    Accepted Solution

    SQL Helper class is a wrapper over ADO.NET objects & functions. It provides a wrapper functionality over basic objects (SQLConnection, SQLCommand, Datareader etc) for retreiving & saving the data into database.
    Microsoft provides one sql helper class in the form of Micosoft Application Block.
    LVL 7

    Assisted Solution

    Please follow the below link.....It is very USeful

    LVL 16

    Assisted Solution

    The SqlHelper class contains static methods that facilitate the execution of common data access tasks, including:

        * Calling stored procedures or SQL text commands,
        * Specifying parameter details, and
        * Returning SqlDataReader, DataSet, XmlReader objects, or single values.

    SqlHelper is part of the Data Access Application Block provided free by Microsoft and using the Data Access Application Block will speed your application development by encapsulating the code required to execute stored procedures or SQL text commands, specify parameters and return SqlDataReader, DataSet, XmlReader objects. Because the Data Access Block was developed using the latest best practices, you can be confident that your code will be efficient and scalable.

    Using the Data Access Application Block frees us from the tedious details of data access and allows us to concentrate on the important business logic in our applications. It also reduces the amount of code we must write, which leads not only to quicker development times, but reduced errors, bugs, and typos as well.

    Author Comment

    Thankyou for your help

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK ( for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now