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
802 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
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Suggested Solutions

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

738 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