What products do I need for .NET application?

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
unidirect2pro
Posts: 10
Joined: Tue 03 Jul 2012 06:52

What products do I need for .NET application?

Post by unidirect2pro » Sun 16 Mar 2014 15:22

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.

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: What products do I need for .NET application?

Post by Shalex » Tue 18 Mar 2014 12:36

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.

Post Reply