Database Helper Class Library to Ease Database Operation

falconsoon

Rate me:

3.09/5 (9 votes)

14 Apr 2007CPOL4 min read

87.6K

Database Helper Class Library to Ease Database Operation

article_src.zip
- DbHelper
  - AssemblyInfo.cs
  - DataException.cs
  - DBCommon.cs
  - DBCriteria.cs
  - DBHelper.chm
  - DBHelper.csproj
  - DBHelper.csproj.user
  - DbHelper.ndoc
  - DBHelper.sln
  - DBHelper.suo
  - DBHelper.xml
  - DBInteractionBase.cs
  - DBKey.cs
  - DBRelation.cs
  - DBRelationCollection.cs
  - DBTypeInfo.cs
  - Field.cs
  - IConnectionProvider.cs
  - InternalDataComparationBase.cs
  - Microsoft.ApplicationBlocks.ExceptionManagement.csproj
  - SqlConnectionProvider.cs
  - SqlDataSetHelper.cs
  - SqlDBInteractionBase.cs
  - SqlHelper.cs
  - SqlHelperParameterCache.cs
  - SqlTableHelper.cs
  - SqlTableHelperCollection.cs
  - SqlTableRelationCollection.cs
  - SqlUtils.cs
- Microsoft.ApplicationBlocks.ExceptionManagement.Interfaces
  - AssemblyInfo.cs
  - InterfaceDefinitions.cs
  - Microsoft.ApplicationBlocks.ExceptionManagement.Interfaces.csproj
  - Microsoft.ApplicationBlocks.ExceptionManagement.Interfaces.csproj.user
  - Microsoft.ApplicationBlocks.ExceptionManagement.Interfaces.xml
  - Microsoft.ApplicationBlocks.ExceptionManagement.sln
  - Microsoft.ApplicationBlocks.ExceptionManagement.suo
- Microsoft.ApplicationBlocks.ExceptionManagement
  - AssemblyInfo.cs
  - BaseApplicationException.cs
  - ExceptionManager.cs
  - ExceptionManagerExceptions.cs
  - ExceptionManagerInstaller.cs
  - ExceptionManagerInstaller.resx
  - ExceptionManagerSectionHandler.cs
  - ExceptionManagerText.resx
  - ExceptionManagerText.xsd
  - ExceptionManagerText.xsx
  - Microsoft.ApplicationBlocks.ExceptionManagement.csproj
  - Microsoft.ApplicationBlocks.ExceptionManagement.csproj.user
  - Microsoft.ApplicationBlocks.ExceptionManagement.xml
  - Microsoft.ApplicationBlocks.sln
  - Microsoft.ApplicationBlocks.suo
- Readme_src.txt
Article_demo.zip
- create sample database.sql
- DBHelperQuickHelperSamples
  - DBHelperQuickHelperSamples.sln
  - DBHelperQuickHelperSamples.suo
  - DBHelperQuickHelperSamples
    - App.ico
    - AssemblyInfo.cs
    - DBHelperQuickHelperSamples.csproj
    - DBHelperQuickHelperSamples.csproj.user
    - frmSqlHelper.cs
    - frmSqlHelper.resx
- DBHelperQuickInsUpdDelSamples
  - DBHelperQuickInsUpdDelSamples.sln
  - DBHelperQuickInsUpdDelSamples.suo
  - DBHelperQuickInsUpdDelSamples
    - AssemblyInfo.cs
    - DBHelperQuickInsUpdDelSamples.csproj
    - DBHelperQuickInsUpdDelSamples.csproj.user
    - frmInsUpdDel.cs
    - frmInsUpdDel.resx
- DBHelperQuickRelationshipSamples
  - DBHelperQuickRelationshipSamples.sln
  - DBHelperQuickRelationshipSamples.suo
  - DBHelperQuickRelationshipSamples
    - App.ico
    - AssemblyInfo.cs
    - DBHelperQuickRelationshipSamples.csproj
    - DBHelperQuickRelationshipSamples.csproj.user
    - frmRelationship.cs
    - frmRelationship.resx
- DBHelperQuickSelectSamples
  - DBHelperQuickSelectSamples.sln
  - DBHelperQuickSelectSamples.suo
  - DBHelperQuickSelectSamples
    - AssemblyInfo.cs
    - DBHelperQuickSelectSamples.csproj
    - DBHelperQuickSelectSamples.csproj.user
    - frmSelect.cs
    - frmSelect.resx
- Readme_demo.txt

To compile sourcecode, perform the following in sequence.

1. Open Microsoft.ApplicationBlocks.ExceptionManagement.Interfaces solution
   and build it.

2. Open Microsoft.ApplicationBlocks.ExceptionManagement solution
   and build it. If Microsoft.ApplicationBlocks.ExceptionManagement.Interfaces.dll
   reference is broken, remove and readd it based on dll compiled in step 1.

3. Open DbHelper solution and build it. If 
   Microsoft.ApplicationBlocks.ExceptionManagement.dll and 
   Microsoft.ApplicationBlocks.ExceptionManagement.Interfaces.dll are broken,
   remove and readd it based on dll compiled in step 1 and step 2.

Note:
1. All source codes is testing using VS 2003 and SQL Server 2000.
   However the source codes can be compiled too using VS 2005.
2. Only DBHelper namespace has documentation.

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

falconsoon

Malaysia

Had worked as analyst programmer for 4 years. Now helping in family business but still involved actively in .Net development whenever there is a free time.

Database Helper Class Library to Ease Database Operation

License

Comments and Discussions