Solved

Microsoft Patterns and Practices - Trying to install and built a trivial (is anything trivial anymore) Enterprise Library Data Access Application Block

Posted on 2007-12-06
19
800 Views
Last Modified: 2013-12-19
I have been looking for a tutorial on Microsoft's Patterns and Practices that:
1. Is current
2. Points me to the correct installation packages for the Patterns and Practices
3. Gives a complete example of building a database project to connect to an Oracle database and retrieve a resultset.

So far,  I find references to DLLs and methods that are no longer used...???
ie.  
      Microsoft.Practices.EnterpriseLibrary.Common
      Microsoft.Practices.EnterpriseLibrary.Configuration
      DBCommandWrapper  (where is it?)


0
Comment
Question by:Howard Bash
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 10
  • 9
19 Comments
 
LVL 21

Expert Comment

by:surajguptha
ID: 20422993
http://msdn2.microsoft.com/en-us/library/ms998572.aspx
That would be the link for the latest patterns and practices...
Patterns and pratices are a series of proven practices like CAB/ SCSF/ Enterprise Library/UIP etc

Enterprise Libarary Data Access Application block can be used to connect to the database and get data.
Please check http://codeplex.com/entlib for the latest versions and examples....

You will have to install the EL 3.0/ 4.0 to be able to use these DLL's
0
 
LVL 1

Author Comment

by:Howard Bash
ID: 20423002
Can you direct me to the Enterprise Libraries 3.0/4.0 that are required?
0
 
LVL 21

Expert Comment

by:surajguptha
ID: 20423122
0
MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

 
LVL 1

Author Comment

by:Howard Bash
ID: 20423201
This is all quite confusing.  The link above send me to a download of :
Enterprise Library 3.0  April 2007

The link : http://msdn2.microsoft.com/en-us/library/ms998572.aspx
Takes me to a page for Patterns and Practices but not a download page.

I haven't a clue which I need and which versions are for which...

Can you provide the direct URL(s) to the installs that I require?  Also,  some complete tutorial would be grand (Data Blocks with Oracle in particular).

Also,  there is a Configuration tool and the usages described do not seem to match the tool.
The steps say to lauch it and right click to add an application node (it adds an application configuration node...),  and then right click to add a new node and add new Data Access Application which will add "TWO" more nodes (it only adds one),  called Configuration Application Block and Data Access Application Block.

Not enough concrete examples for all this...


0
 
LVL 21

Expert Comment

by:surajguptha
ID: 20423394
0
 
LVL 1

Author Comment

by:Howard Bash
ID: 20423410
Yes.  That is Ent Lib 3 and there exists and Ent Lib 3.1 and apparently 3.5 (or 4.0) will be out soon.

I always assumed that the highest version number is the desired install...
0
 
LVL 21

Accepted Solution

by:
surajguptha earned 500 total points
ID: 20423488
But again the latest version might have a lot of bugs. It is better to use stabler versions than the most recent versions in my opinion....
0
 
LVL 1

Author Comment

by:Howard Bash
ID: 20423549
OK.  So,  then I need to get Ent Lib 3.0.  

Is that all and do you have any thoughts about attaching to Oracle?

Thanks,
Howard
0
 
LVL 21

Expert Comment

by:surajguptha
ID: 20423591
When you install EL 3.0 , there will be enough examples/quick starts for that. If you have any difficulty interpreting them let me know...
0
 
LVL 1

Author Comment

by:Howard Bash
ID: 20423847
I cannot find the assembly "Microsoft.Practices.EnterpriseLibrary.Configuration"  is it that I am looking at some old code samples?

Here is the snippet :
  Dim db As Database = DatabaseFactory.CreateDatabase()
-->>> Dim cmd As dbcommandwrapper = db.GetStoredProcCommandWrapper("someProcName")



0
 
LVL 1

Author Comment

by:Howard Bash
ID: 20423864
I do not see any quickstart samples associated with installing EL 3.0.

Is that perhaps added with another install?
0
 
LVL 21

Expert Comment

by:surajguptha
ID: 20424044
Start -> Program Files -> MS Patterns and Practices -> EL 3.0 -> Qucik Start Samples
0
 
LVL 1

Author Comment

by:Howard Bash
ID: 20427357
So, after installing the source code/quick start,  I tried to run the BlockFactory solution and all Application Block assemblies were not found.

For example: Microsoft.Practices.common (is that Microsoft.Practices.EnterpriseLibrary.Common?)
and others are not to be found with or without the "EnterrpiseLibary" inserted in the assembly name.

These installs and the associated block framework are huge and not particualary approachable.  Even taking the loadable C:\EntLib3Src\Quick Starts\Data\VB\DataAccessQuickStart solution,  I am perplexed.  That "solution" is a mix of perhaps 50 modules composed of VB and C#.  These are "Quick Starts"?  Plus they talk to SQL not other data stores like Oracle (I did mention my need to connect to Oracle earlier in this thread).  Plus,  that solution does not refer to the blocks other than an ObjectBuilder assembly.

One simple example ???


0
 
LVL 21

Expert Comment

by:surajguptha
ID: 20427487
HBash, The one of the reasons people would use DataAccess Application Blocks is so that they can connect to any database using it. You can be sure you would be able to talk to Oracle with it...

Just take some time with the Quick Starts and you will be able to figure it out....
Here's some Learn DAAB article... It is a little old but the way it is used is almost same...
http://aspalliance.com/688
0
 
LVL 1

Author Comment

by:Howard Bash
ID: 20427618
I had tried the project referenced at the above URL and this is a web application,  plus,  again,  it is using assemblies that are not part of the 3.0 EL.

And the configuration application does not behave as the article describes.  When you select new application,  it does not create a Configuration Application Block and a Data Access Application Block,  it creates an Application Configuation node and that is all.  So,  using this utility is yet another disconnect.

Missing and referenced assembly in the sample from the above aspaliance URL :
Microsoft.Practices.EnterpriseLibrary.Configuration.dll
(only comes with the zip file, not EL 3.0)
0
 
LVL 21

Expert Comment

by:surajguptha
ID: 20428014
Even taking the loadable C:\EntLib3Src\Quick Starts\Data\VB\DataAccessQuickStart solution,  I am perplexed.  That "solution" is a mix of perhaps 50 modules composed of VB and C#.  These are "Quick Starts"?

Yes these quick starts actually have references to the actual code of Data Access Application Blocks.... It would contain all these projects.... Are you able to compile it and get it working?
0
 
LVL 1

Author Comment

by:Howard Bash
ID: 20452766
I have built the quickstart, but it talks to sql server...

Also,  what happened to the data type dbcommandwrapper which is referred to in many snippets,  but seems to be gone?
0
 
LVL 21

Expert Comment

by:surajguptha
ID: 20453230
hmm ok here is an article specifically talking about using DAAB with oracle...
http://www.codeproject.com/KB/database/DAAB_On_ODPNet.aspx?print=true
0
 
LVL 1

Author Comment

by:Howard Bash
ID: 20466387
This article want EL3.1 whereas you have recommended that I stick with EL3.0 for the present.

Also,  it would be great to have an non web application to experiment with.

Thanks,
Howard
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to take different types of Oracle backups using RMAN.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question