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
772 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:hbash
  • 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:hbash
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
 
LVL 1

Author Comment

by:hbash
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:hbash
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:hbash
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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 1

Author Comment

by:hbash
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:hbash
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:hbash
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:hbash
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:hbash
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:hbash
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now