Go Premium for a chance to win a PS4. Enter to Win

x
?
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
Medium Priority
?
817 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
  • 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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 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 1500 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
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 how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

885 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