Print Page | Close Window

Suggestions for Multi-Database Solution

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=2800
Printed Date: 08-May-2025 at 12:30pm


Topic: Suggestions for Multi-Database Solution
Posted By: iDave
Subject: Suggestions for Multi-Database Solution
Date Posted: 27-Jun-2011 at 11:22am
Hello to everyone,

We are just starting with DevForce 2010 and would like to know how should we implement the Multi-Database approach to our solutions using your technology.

We came from another technology, LLBLGen Pro. In our solutions, we offer to our clients the freedom to choose from some variety of databases, which are: MySQL, PostgreSQL, Oracle, MS SQL Server, ...
To make things easy to our customers, we created a Wizard, using this, they can choose the database, and type the requiered fields (user, passowrd, ip/host, ports, etc), make connectivity tests, and if all is correct, save the fields (encrypted) in the local machine.

Later in the application, if they call for example, to show a list of... I don't know.. products, we pass the connection string (which is decrypted) to the constructor. And the list is shown.

Thanks in advance.
Dave


Replies:
Posted By: iDave
Date Posted: 04-Jul-2011 at 6:52pm
Is this the appropiate section for my question? Or is this not related to DevForce produkt?

Regards,
Dave

Posted By: sbelini
Date Posted: 05-Jul-2011 at 8:43am
Hi iDave,
I apologize for the delayed response.
 
DevForce will work with all the DBs you mentioned above. (and others too)
 
Also, you can indeed specify the connection programmatically. There is a topic in the http://drc.ideablade.com/xwiki/bin/view/Documentation/configure-programmatically - DevForce Resouce Center explaining the process.
 
Kind regards,
   Silvio.

Posted By: iDave
Date Posted: 08-Jul-2011 at 12:16pm
Hallo Silvio,

Thanks for your kind reply. For a minute I though I posted in the wrong section...
Anyway, one last question, does DevForce 2010 works with Devart data providers?


Print Page | Close Window