dotConnect Universal vs dotConnect for Oracle,MySQL,SQLite..

AKRRKA · Post by **AKRRKA** » Thu 26 Jan 2012 15:15

At the current time tested "dotConnect for Oracle" but there is a desire to use other databases, want to try "dotConnect Universal".
And in the case of successful application of his purchase.

The site says:
The Professional Edition of dotConnect Universal includes the dotConnect for Oracle, dotConnect for MySQL, dotConnect for PostgreSQL, and dotConnect for SQLite data providers (run time of the Standard Edition of these providers).

questions:
1) "dotConnect Universal" fully incorporates and completely replaces the "dotConnect for Oracle", MySQL, PostgreSQL and dotConnect?
2) The most important thing that will alter the transition from "dotConnect for Oracle" on "dotConnect Universal"?

Helen · Post by **Helen** » Tue 31 Jan 2012 09:45

AKRRKA wrote: 1) "dotConnect Universal" fully incorporates and completely replaces the "dotConnect for Oracle", MySQL, PostgreSQL and dotConnect?

dotConnect Universal supports run time of Standard Edition of the mentioned providers and allows using general ADO.NET functionality only.
dotConnect for Oracle includes support for a set of advanced and Oracle-specific features which are not available in dotConnect Universal. In particular, dotConnect for Oracle Professional Edition supports ORMs (Entity Framework and LinqConnect), whereas dotConnect Universal does not.
All written above also applies to dotConnect for PostgreSQL, dotConnect for MySQL, and dotConnect for SQLite vs dotConnect Universal.

For the detailed information about the features of these products, please refer to
http://www.devart.com/dotconnect/oracle/editions.html
http://www.devart.com/dotconnect/mysql/editions.html
http://www.devart.com/dotconnect/postgr ... tions.html
http://www.devart.com/dotconnect/sqlite/editions.html
http://www.devart.com/dotconnect/univer ... tions.html

AKRRKA wrote: 2) "The most important thing that will alter the transition from "dotConnect for Oracle" on "dotConnect Universal"?

If features which you use in dotConnect for Oracle are supported in dotConnect Universal, than you should change the following:
1. Connection string (add "Provider=Oracle;" to your connection string);
2. The type of your connection, command, datareader etc. (for example, OracleConnection -> UniConnection);
3. Maybe some types of parameters.
3.1. If you are using parameters and set their type as OracleDbType, then you should change it to UniDbType.
3.2 Some names of types are the same (for example, OracleDbType.Clob and UniDbType.Clob). But not all names are the same (for example, OracleDbType.Number is UniDbType.BigInt).
For more information please refer to:
http://www.devart.com/dotconnect/univer ... irect.html
http://www.devart.com/dotconnect/oracle ... bType.html
4. Maybe you will have to make some other small changes. You can download a trial edition of dotConnect Universal and try transferring your project from dotConnect for Oracle to dotConnect Universal.
You can download trial edition of dotConnect for Universal on http://www.devart.com/dotconnect/univer ... nload.html

AKRRKA · Post by **AKRRKA** » Wed 01 Feb 2012 11:22

Thanks.
Hmmm. Ok. Please fill this compare table for show all diff features?

Code: Select all

             dotConnect Oracle        dotConnect MySQL   dotConnect Universal

ORM                  Yes                       Yes                   No

features 1           ---                        --                   --
features 2           ---                        --                   --
features 3           ---                        --                   --
     ...
features N           ---                        --                   --

I need to decide what I want to buy and what not.
And whether it is necessary to buy these components, because the final price may be high and not profitable.

I need to get a result the following characteristics.

1) A single source of data.
2) Working with databases Oracle, MySQL, MSSql - (query, edit, delete, stored procedures);
3) ORM;
4) Direct access to database;
5) Reasonable price.

Pinturiccio · Post by **Pinturiccio** » Wed 01 Feb 2012 14:49

We gave you all the necessary references to compare features our providers with dotConnect Universal. I can briefly add that dotConnect Universal does not support ORM features (Entity Framework, Entity Developer, LinqConnect etc.), InterForm, some database-specific features, that are supported in corresponding dotConnect providers.

AKRRKA · Post by **AKRRKA** » Thu 02 Feb 2012 05:20

I need to get as result, following characteristics.

1) One, unified, single DataSource.
2) Working with databases Oracle, MySQL, MSSql - (query, edit, delete, stored procedures);
3) ORM;
4) Direct access to database;
5) Reasonable price.

Please tell me.
What should I buy for this?

It?:
dotConnect Universal ($200)
+ DotConnect for Oracle, ($300)
+ DotConnect for MySQL, ($200)
+ DotConnect for SQL Server. ($100)
Sum: $800 for single pro licenses?

And, dotConnect Universal with others in combination will work or they replace each other?

Pinturiccio · Post by **Pinturiccio** » Thu 02 Feb 2012 14:55

1) Could you please tell us what did you mean when wrote:

AKRRKA wrote:1) One, unified, single DataSource.

If you meant the DataSource component for web applications, this component is available only in database-specific providers (e.g. OracleDataSource in dotConnect for Oracle).

2) You can execute queries and stored procedures on Oracle, MySQL, SQL Server via UniCommand:
http://www.devart.com/dotconnect/univer ... mmand.html

3) dotConnect Universal does not provide ORM support. To use ORM-based access to several DBMSs, you can use LinqConnect, an ORM solution developed by Devart: http://www.devart.com/linqconnect/overview.html . In particular, its installation package includes the version of Entity Developer that allows creating LinqConnect models for the following DBMSs: Oracle, MySQL, PostgreSQL, SQLite, SQL Server, SQL Server Compact Edition. As for the ASP.NET-specific functionality of LinqConnect, you can try the DbLinqDataSource component:
http://www.devart.com/linqconnect/docs/ ... nding.html).
LinqConnect product contains Express editions of dotConnects providers (Oracle, MySQL, PostgreSQL, SQLite, SQL Server). If you want to use direct mode for connecting to Oracle you will have to purchase dotConnect for Oracle, because direct mode is not supported in dotConnect for Oracle Express Edition. You can purchase LinqConnect and dotConnect Universal and use LinqConnect with dotConnect for Oracle, dotConnect for MySQL, and dotConnect for SQL Server Standard Edition from dotConnect Universal.
Otherwise, if you need Entity Framework support, you can use several Devart data providers (e.g., dotConnect for Oracle Professional and dotConnect for MySQL Professional):
http://www.devart.com/dotconnect/
Their Professional editions include versions of Entity Developer that can be used to create both Entity Framework and LinqConnect models for the corresponding DBMS.

4)dotConnect Universal includes the Direct connection mode, and allows accessing different DBMSs. However, it provides general ADO.NET functionality only.

dotConnect Universal is shipped with support for set of ADO.NET providers.

dotConnect for Oracle provides direct access to Oracle database server with or without the Oracle Call Interface (OCI). The data provider supports Oracle Client software version 8.0 and later. For more information refer to the Using dotConnect Universal with dotConnect for Oracle topic http://www.devart.com/dotconnect/univer ... irect.html

dotConnect for MySQL is data provider for direct access to MySQL database server for the Microsoft .NET Framework. Data provider can access MySQL server either using native MySQL network protocol directly or through the MySQL client library. For more information refer to the Using dotConnect Universal with dotConnect for MySQL topic http://www.devart.com/dotconnect/univer ... irect.html

The .NET Framework Data Provider for SQL Server uses its own protocol to communicate with SQL Server. It is lightweight and performs well because it is optimized to access a SQL Server directly without adding an OLE DB or Open Database Connectivity (ODBC) layer. For more information refer to the Using dotConnect Universal with SQL Client topic http://www.devart.com/dotconnect/univer ... lient.html

5) If you have some questions when deciding to purchase our products, please contact with our sales department by e-mail sales at devart dot com

AKRRKA wrote:And, dotConnect Universal with others in combination will work or they replace each other?

They will work but note that all Devart data providers use a common assembly (Devart.Data.dll), so it is necessary to install compatible provider versions. We release our ADO.NET data providers on the same date, thus releases from the same date should be compatible. For more information on the version of the products and their respective date of release, visit:
http://www.devart.com/dotconnect/univer ... story.html
http://www.devart.com/dotconnect/oracle ... story.html
http://www.devart.com/dotconnect/mysql/ ... story.html
http://www.devart.com/dotconnect/sqlser ... story.html

AKRRKA · Post by **AKRRKA** » Fri 03 Feb 2012 13:13

1) A single source of data, I mean, one component of the release of DataSource connection to the database. Able to work with different databases.
First, we need only to WinForms application, and the prospect of his own, and in Web-application.

The development is carried out in accordance with the pattern MVP, finally now has a View - only WinForm application, and after the plan and the Web.
In both views, I would like to have the opportunity to apply ORM.

2) Very good.

3) Can I use "dotConnect Universal" + "LinqConnect" to get as result, full working ORM?

4) I understand.

5) Ok.

PS: MVP - http://en.wikipedia.org/wiki/Model-view-presenter

StanislavK · Post by **StanislavK** » Tue 07 Feb 2012 16:11

As for the data source, please take a look on the LinqConnect DataContext class:
http://www.devart.com/linqconnect/docs/ ... ntext.html
http://www.devart.com/linqconnect/docs/ ... cting.html
It allows accessing different databases in a uniform way. For example, to work with different DBMSs, you have only to create several mapping files, and pass the proper file to the DataContext constructor to work with a particular DBMS.

Please tell us if this is the functionality you are interested in.

Concerning the product choice, LinqConnect itself provides a complete ORM solution, as it includes the free versions of our data providers. To use the Direct connection mode, however, you will also need the runtime of dotConnect for Oracle Standard. If you are interested in some advanced features of other data providers as well, you can install dotConnect Universal Professional. Thus, you may be interested in one of the following combinations:
- LinqConnect and dotConnect Standard;
- LinqConnect and dotConnect Universal.

AKRRKA · Post by **AKRRKA** » Wed 08 Feb 2012 05:36

StanislavK Thanks!
Can I use "dotConnect Universal" to connect to Oracle on behalf of the sys and sysatem, make queries with the privileges of the user?

StanislavK · Post by **StanislavK** » Wed 08 Feb 2012 16:01

Yes, dotConnect Universal allows accessing Oracle servers with system accounts (provided that you have privileges/credentials needed to use these accounts).