Click here to Skip to main content
15,299,443 members
Articles / Programming Languages / C#
Posted 4 Aug 2009

Tagged as


61 bookmarked

Using the Microsoft Enterprise Library Data Access Application Block – Part I

Rate me:
Please Sign up or sign in to vote.
4.29/5 (16 votes)
4 Aug 2009CPOL4 min read
Using the Microsoft Enterprise Library Data Access Application Block to insert data into a database.


I have been using various Microsoft Enterprise Library application blocks in my application development. The most common tasks for any application are database transactions. I have used the Enterprise Library Data Access Application Block and found it extremely easy and simple to integrate and use.

The Enterprise Library Data Access Application Block simplifies development tasks that implement common data access functionality. Applications can use this application block in a variety of situations, such as reading data for display, passing data through application layers, and submitting changed data back to the database system. The application block includes support for both Stored Procedures and in-line SQL.

In this article, let me share how to integrate and use the Data Access Application Block for inserting data into a database.

Please note that I have used the Microsoft Enterprise Library 4.1 – October, 2008 release. It works on .NET framework 3.5 and Visual Studio 2008. You can download Microsoft Enterprise Library 4.1 from this URL:

Integration and Usage

  • Code: In the attached source, I have put in the Data Access Layer class, the Entity class, the EventLog class, and the SQL script to create the table and the relevant Stored Procedure. And also the relevant assemblies from the Data Access Application block. The code is to save user information (Insert and Update) in the database. I have put in the classes in the same folder, but they are from a different namespace and assembly. It is better practice to put in a different namespace for different layers and in a different assembly.
  • Explanation: First, we need to install Microsoft Enterprise Library 4.1 and get hold of the assemblies “Microsoft.Practices.EnterpriseLibrary.Common.dll” and “Microsoft.Practices.EnterpriseLibrary.Data.dll” and add the reference to the same in your project. In the attached sample, you will find the necessary DLL in case you don’t want to to download and install Microsoft Enterprise Library 4.1.
  • User.cs: The Entity Layer class. This class is used to pass user data between various layers.
  • UserDAC.cs: The Data Access Layer class. This class uses the Entity class to get the data members, and passes the same to be inserted into the database using the Data Access Application block. It executes a Stored Procedure to save user information (New User or Edit User). Once the database transaction is done, it responds back with the message ID and message string. For a successful transaction, the message ID would always be a positive numeric integer carrying the new user ID for the new user and the user ID for the modified user. The message string would carry the transaction message from the Stored Procedure. I have used static messages for the purpose of the demo, but it is configurable. This class should be called from the Business Layer class to save data into the database. The Business Layer will pass in the Entity object storing the user information and gets back the message ID and the message string. The User Data Access class will also log the error in the Application Event Log using the EventLog class.
  • C#
    public void SaveUser(User vobjUser, out int vintMessageID, out string vstrMessage)
        //Use the database connection string here...
        Database objDB = new SqlDatabase(ConnectionString);
        using (DbCommand objCMD = objDB.GetStoredProcCommand("sprocSample_SaveUser"))
            objDB.AddInParameter(objCMD, "@intUserID", 
                                 DbType.Int32, vobjUser.UserID);
            objDB.AddInParameter(objCMD, "@strUserName", 
                                 DbType.String, vobjUser.UserName);
            objDB.AddInParameter(objCMD, "@strUserPassword", 
                                 DbType.String, vobjUser.UserPassword);
            objDB.AddInParameter(objCMD, "@strFirstName", 
                                 DbType.String, vobjUser.FirstName);
            objDB.AddInParameter(objCMD, "@strLastName", 
                                 DbType.String, vobjUser.LastName);
            objDB.AddOutParameter(objCMD, "@intErrID", 
                                  DbType.Int32, Int32.MaxValue);
            objDB.AddOutParameter(objCMD, "@strMessage", DbType.String, 255);
            vintMessageID = 
              Convert.ToInt32(objDB.GetParameterValue(objCMD, "@intErrID"));
            vstrMessage = objDB.GetParameterValue(objCMD, "@strMessage").ToString();
            vobjUser.UserID = vintMessageID > 0 ? vintMessageID : 0;
            catch (Exception ex)
                EventLog objLog = new EventLog();
                throw ex;

    The above method saves the user into the database by calling the procedure “sprocSample_SaveUser”. The using keyword closes and disposes the relevant object being used for the database transaction once the transaction is complete, so no need to close the database connection explicitly.

  • EventLog.cs: The Framework / Utility layer class. This class is used to log error information into the Application Event Log of the system. Refer my article Using Microsoft Enterprise Library Logging Application Block for details on the event logging mechanism using the Microsoft Enterprise Library Logging Application Block.
  • SQLScripts.sql: The SQL scripts to create the database table and the Stored Procedure used in the example.


By now, you should be able to understand how simple it is to use the Enterprise Library 4.1 Application Blocks for Data Access to save data into a database. I will come up with some more articles on the Data Access Application block and the layered architecture.

To study more on the Microsoft Enterprise Library 4.1 Application Blocks, refer to this URL:


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


About the Author

Comments and Discussions

QuestionCrud operation using Microsoft Enterprise Library Pin
paras_zalariya1226-Apr-14 3:18
Memberparas_zalariya1226-Apr-14 3:18 
GeneralMy vote of 5 Pin
josephalmenario1-Jul-13 2:03
Memberjosephalmenario1-Jul-13 2:03 
Questionuse this [DataMember] with [DataMapping("idEmployee")] Pin
alsholi20-Apr-12 5:02
Memberalsholi20-Apr-12 5:02 
GeneralMy vote of 4 Pin
sabasundaram8-Jun-11 18:32
Membersabasundaram8-Jun-11 18:32 
GeneralMy vote of 2 Pin
vaseem_sm78624-Dec-10 1:26
Membervaseem_sm78624-Dec-10 1:26 
GeneralLimitations of regular Caching Application Block Pin
wesnur16-Nov-09 17:23
Memberwesnur16-Nov-09 17:23 
QuestionHow to implement transaction handling? Pin
Hemant.Kamalakar30-Aug-09 21:37
MemberHemant.Kamalakar30-Aug-09 21:37 
GeneralVery Good Article Pin
SaswatiS26-Aug-09 17:42
MemberSaswatiS26-Aug-09 17:42 
GeneralRe: Very Good Article Pin
Robin_Roy26-Aug-09 21:29
MemberRobin_Roy26-Aug-09 21:29 
GeneralGood One Pin
lxjhonson21-Aug-09 1:44
Memberlxjhonson21-Aug-09 1:44 
GeneralRe: Good One Pin
Robin_Roy26-Aug-09 21:27
MemberRobin_Roy26-Aug-09 21:27 
GeneralMy Vote of 5 Pin
albert_cook10-Aug-09 16:33
Memberalbert_cook10-Aug-09 16:33 
GeneralRe: My Vote of 5 Pin
Robin_Roy26-Aug-09 21:25
MemberRobin_Roy26-Aug-09 21:25 
QuestionThanks for article Pin
Koltz6-Aug-09 6:07
MemberKoltz6-Aug-09 6:07 
AnswerRe: Thanks for article Pin
Robin_Roy26-Aug-09 21:24
MemberRobin_Roy26-Aug-09 21:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.