Devart Forums

Hello. I need ADO .NET access to two types of databases:

--- DB2
--- MySQL

I have already purchased two Devart products:

--- dotConnect DB2
--- dotConnect Universal

I prefer one comprehensive connector that works (transparently) with both databases. To my understanding, the Universal connector requires the DB2 connector. I have two questions and one comment:

(1) Do I need any products from Devart?
(2) If yes, which ones? Or, which non-Devart alternatives?
(3) I want the best solution, not the least expensive solution.

My IDE is Visual Studio 2013, but I do not need any fancy design tools. Your advice and answers will be greatly appreciated.

Thank you and regards,

David Woosley
AppNation Inc.

unidirect2pro wrote:I need ADO .NET access to two types of databases:
--- DB2
--- MySQL

Please specify the exact ADO.NET functionality you want to employ in your application.
If you are interested in a plain ADO.NET, we recommend you to use dotConnect Universal Professional because it includes the UniSQL feature: http://www.devart.com/dotconnect/univer ... nisql.html.
The advanced functionality (e.g.: Entity Framework support) is available in Professional editions of separate dotConnect products: dotConnect for MySQL and dotConnect for DB2.

unidirect2pro wrote:To my understanding, the Universal connector requires the DB2 connector.

Both dotConnect Universal and dotConnect for DB2 are wrappers of IBM DB2 .NET Data Provider, so IBM.Data.DB2.dll should be available on a target workstation. An advantage of using the Devart providers is an extended functionality comparing to IBM.Data.DB2.dll.