SqlHelper Source Code (MS Data Access Block)

SqlHelper is part of the Data Access Blocks Released by Microsoft.

The Application Blocks created by Microsoft are "best practices" for each of the different blocks they have implemented.  The Data Access Block is meant to give you best practices to connect to Sql Server.

You can download the Application Data Access Blocks v2 here (installation + source code from Microsoft)

You can view the Source Code for SqlHelper here (online HTML format)

Here is the compiled ApplicationBlocks DLL and XML file incase you do not have permission to install or you only want the DLL+XML Documentation

In order to use it, either put the source code (.cs files) in your App_Code subfolder, or put the .dll in your Bin subfolder.

By using this intermediate layer between the database and your source code, you also have the option or ability to make system wide changes to the way your SQL connections are handled, which can come in handy in the future.

For example, you can add a line to your SqlHelper source to insert a record into a ‘history table’ of some sorts after every insert or delete operation.  If you are directly calling SqlCommand to insert, you will not have the ability to do that.

Enjoy
         

Related Reading:

JavaScript: The Good Parts

Head First Java, 2nd Edition

Effective Java (2nd Edition)

Other Interesting Posts

• PHP VS. ASP.NET
• Creating SqlParameters Best Practices
• Creating Maintainable Database Queries In C# (with source code)