Application Blocks 2006

[Guest]

Hello all, just a quickie!

What's the advantage / disadvantage in using the January 2004 application
block to return data from an Oracle Database rather than just use the
standard System.Data.OracleClient dll?

I'm just trying to figure out what's best!

Thanks,

Jon

 

[sloan]

The EnterpriseLibrary.Data . is a higher level (abstract) way to talk to
databases.

So ... you can use the same syntax to talk to Sql Server, OLEDB, DB2 or
Oracle.

The other advantage is that is its "time tested" code, with lots of people
using it, testing it, reporting issues, fixes.
You'll never get that kind of manhours out of a personal library.

The other nice thing is the complete setup of db connection parameters via a
dataConfiguration.config file. These are nice for deploying.

Make sure you read if the EnterpriseLibrary you are using matches your
environment.
1.1 or 2.0

...
The EnterpriseLibrary.Data relies on a Design Pattern called the "Factory
Design Pattern".
http://www.dofactory.com/Patterns/PatternFactory.aspx

..............