How to make an Comercial Aplicaction database independant (refrase)

[Gustavo De la Espriella]

I'm refrasing a question I posted earlier because I didn't explain myself.

I need an efficient way to make an especific comercial application able to
use whatever database the
client prefers a main database, even after the initial installation.
It's a Balanced Scorecard System. And though the structure remains the same,
the client should be able to choose its database (MySQL, SQLServer, Acces,
etc).

Thanks,
Gustavo De la Espriella

 

[Gopal \(FMS, Inc.\)]

If you know your application is always only going to use SQL Server as its
persistent storage format, you can safely go ahead and program using the
SQLClient objects - SQLConnection, SQlDataAdapter, SqlCommand and so forth.
However it can be beneficial to write code more generically so that it
utilitizes the underlying base classes rather than the specific derived
child classes. For example you can write a generic handler that would work
with either a SQLConnection object or an OLEDbConnection object. Simply
write the code in your common handler so that it refers only to the
underlying base classes. Then you can pass specific derived objects to the
common handler, and the same code will work with both types.

BTW, the FMS Total .NET Sourcebook has code to do this, and much, much,
more. Please visit: http://www.fmsinc.com/dotnet/SourceBook/

Hope this helps you.

 

[Oleg Ogurok]

..NET framework 2.0 will support pluggable data access drivers.
With 1.1, it's still pretty messy.

-Oleg.

 

[Mauricio Magni]

Hello

Take a look to Data Abstract, currently for Delphi but will be available for
..NET soon
http://www.remobjects.com/page.asp?id={A1FEB4A5-CC12-4FFF-9C47-7116910DCBB8}
http://www.remobjects.com/page.asp?id={680DEBDB-413A-48D9-AF59-9D3E3FE48F82}

I hope this help you.
Mauricio.

 

[bruce barker]

you should implement the database factory model. while this pattern is easy
to develop, supporting multiple databases requires some hard decisions. not
all databases support the same features or sql syntax, so you will need to
decide on how to handle - lowest common code, specialized code for each
database, etc.

-- bruce (sqlwork.com)



| I'm refrasing a question I posted earlier because I didn't explain myself.
|
| I need an efficient way to make an especific comercial application able to
| use whatever database the
| client prefers a main database, even after the initial installation.
| It's a Balanced Scorecard System. And though the structure remains the
same,
| the client should be able to choose its database (MySQL, SQLServer, Acces,
| etc).
|
| Thanks,
| Gustavo De la Espriella
|
|

 

[Matt Berther]

Hello Gustavo De la Espriella,

See my response to your original post. I describe an implementation using
AbstractFactory and DataMapper to acheive this.