Enterprise Library Data Access Application Block In C# .NET

Firstly, I will talk about Enterprise Library

What is Enterprise Library and how it work

Enterprise Library is a framework and it is an integration pack for all Microsoft products (C#, Azure, Sharepoint and more).

It provides all application recommended operations like Validations, Exception Handling, Logging, Data Transfer objects, etc.

I recommend it, If your application deals with any bulk data Insert, Select and Update. Good at performance wise also.

The following computer screens will guide you.

Step 1: Create empty website



Step 2: Add SQL Server database template to your application.



Step 3: Add one Web Form or any sample page to your website.



Here I recommended you, a class that use expose DTO.

Step 4: Add one class to your website to develop Enterprise DAL and DTO (Data Transfer Objects).



Next find connection string to your Database.mdf with help of the following screen,

The above screenshot sqlDataSource will help you to get connection string to your project database.mdf and later you can remove from your page.



Find connection string and add it to your web.config file.



Next add DB stuff to your Testconnection Database Table and Procedures.



Table Design has been completed and next step is for Stored Procs.



All necessary stuff has been made and now lets come into application and add packages.
// Required : Install-Package EnterpriseLibrary.Data



Required namespaces