.net Database Utility Library

The library works in any .NET or ASP.NET project, using C#, VB.net or any other .NET language.

It will eliminate repetitive tasks when developing database-driven applications.

Features:

• Full MSDN Style HTML documentation with example code. HTML Documentation can be located at http://joel.net/docs/DatabaseUtility.
• Works in ANY .net project. C#, VB.NET, ASP.NET or any other supported .Net language.
• Retreive a DataTable with only one command. No longer have create a SqlDataAdapter and call the Fill() method to fill your DataTable. From retreiving a DataTable, SqlDataReader, Scalar or simply executing a NonQuery, you can do it all with only one command.
• No need to Open and Close a connection object. The SqlConnection object will automatically be Opened (if closed) and Closed at the end (if closed when calling method). If SqlConnection object is Open when calling the method, the SqlConnection object will be left open. The SqlConnection object will automatically be closed (if closed when calling method) with a SqlDataReader object when calling SqlDataReader's Close() method.
• All input variables for methods are identical. Changing code to return a Datatable instead of a SqlDataReader is easy.
• 15 overrides for each of the 4 methods. The control has 4 methods ExecuteDataTable, ExecuteNonQuery, ExecuteReader, ExecuteScalar each with 15 overrides -- that's a total of 64 methods!
• Global Connection's can be used in any project.
• Write less code.