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

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?)


LVL 1
Howard BashSenior Software EngineerAsked:
Who is Participating?
 
surajgupthaConnect With a Mentor Commented:
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
 
surajgupthaCommented:
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
 
Howard BashSenior Software EngineerAuthor Commented:
Can you direct me to the Enterprise Libraries 3.0/4.0 that are required?
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
surajgupthaCommented:
0
 
Howard BashSenior Software EngineerAuthor Commented:
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
 
Howard BashSenior Software EngineerAuthor Commented:
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
 
Howard BashSenior Software EngineerAuthor Commented:
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
 
surajgupthaCommented:
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
 
Howard BashSenior Software EngineerAuthor Commented:
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
 
Howard BashSenior Software EngineerAuthor Commented:
I do not see any quickstart samples associated with installing EL 3.0.

Is that perhaps added with another install?
0
 
surajgupthaCommented:
Start -> Program Files -> MS Patterns and Practices -> EL 3.0 -> Qucik Start Samples
0
 
Howard BashSenior Software EngineerAuthor Commented:
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
 
surajgupthaCommented:
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
 
Howard BashSenior Software EngineerAuthor Commented:
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
 
surajgupthaCommented:
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
 
Howard BashSenior Software EngineerAuthor Commented:
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
 
surajgupthaCommented:
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
 
Howard BashSenior Software EngineerAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.