Working with SqlServer using Microsoft Enterprise Library

Microsoft Enterprise Library provide good solution for your database connection
Download Microsoft Enterprise Library 5.0

1. Modify your web.config file



2. import class library



3. Create accesses which related with your database table



4. Usage

i - Execute your sql query

ii - Execute your Stored Procedure

iii - Execute your Stored Procedure with output parameters

iv - ExecuteSprocAccessor use for retrieve the list of data