Monday, August 17, 2009

How to configure Visual Studio 2005/2008 to use Enterprise Library for Data Access?

Here is the quickest way to configure visual studio to use Enterprise Library.

System Requirements:

-Microsoft Visual Studio 2005/ 2008 development system (any of the following editions):
Standard Edition
Professional Edition
Team Edition for Software Developers
Team Edition for Software Testers
Team Edition for Software Architects
Team Suite

-For the Data Access Application Block, the following is also required:

A database server running a database that is supported by a .NET Framework 2.0/3.5 data provider. This includes SQL Server 2000 or later

-To run the Unit Tests, the following is also required:

Visual Studio 2008 Professional or Visual Studio 2008 Team Edition. Enterprise Library includes both unit test binaries and source code.

-For the Logging Application Block, the following is also required:
Stores to maintain log messages. If you are using the MsmqTraceListener trace listener to store log messages, you need a message queue. If you are using the DatabaseTraceListener trace listener to store log messages, you need a database server. If you are using the EmailTraceListener trace listener to store log messages, you need an SMTP server.

After these requirements you need to download Enterprise Library 4.0 - May 2008
(It working fine for both VS2005/2008).
Download it here

After you download it open both Visual Studio 2005/2008 and Enterprise Configuration Libary tool(C:\Program Files\Microsoft Enterprise Library May 2008\bin bleu icon)

-After you open the config tool you need add Data Access Block from it.You will see this image

-Right Click(RC) on Enterprise Library Configuration and choose New Application

-After that RC on Application Configuration and choose New then Data Access Application Block

-Change the connection Name and string that will match the connection string of your applicatio.
Database=Database;//name of your database

Server=(local)\SQLEXPRESS;Integrated Security=SSPI //name of your server

-Save it on the location of your application aroung web.config or app.config

-Open VS 2005/2008 ,RC on web.config and add these 3 configurations between configuration tags(You can get this by openning the saved configuration from the tool)

That`s all you need to get started with Enterprise Library Configuration .
You are ready to start Data Access Block.

Talley Ouro,
Developer Cary,NC,USA

No comments:

About Me

My photo
Raleigh, NC, United States
I am a software developer based in Raleigh,NC,USA.I design softwares and systems ;i also do consulting for companies worldwide.I program with these languages:VB.NET 2003/2005/2008;C#;Java(fun),SQL(200,2005,2008);ASP.NET 2.0/3.5;ASP.NET AJAX;ASP.NET MVC;JavaScript;JQuery;Windows Workflow Foundation;Web Services.I have 4 years + in programming.