dotConnect for Oracle is a great database connectivity option based on the ADO.Net architecture. It is basically a database connectivity option for your database related dynamic websites, web applications and windows applications to work. It provides a easy to use interface and is also easy to deploy. It is available through Nuget packages in Visual Studio IDE. Review collected by and hosted on G2.com.

The solution is useful and has no disadvantages. It can be used without having Oracle client software. dotConnect for Oracle is a Object Relational Mapping data provider for Oracle which helps in developing database driven applications. Thus it helps developers to code in .net and connect Oracle database using dotConnect. It makes developers life easy by providing wizard for connecting database. Review collected by and hosted on G2.com.

As a native .Net provider, it offers faster data access.

Get benefit of comprehensive Oracle support.

Office Integration with Visual studio for connection String building, data exploration and object design.

Provide various security features as encryption, authentication, and Authorization. Review collected by and hosted on G2.com.

Express edition has limited feature. Professional edition requires a paid license.

It has potentially high learning curve.

Choosing DotConnect may tie you to it. Review collected by and hosted on G2.com.

It is very user-friendly, and there is not a strict learning curve associated with it Review collected by and hosted on G2.com.

There is nothing "unhelpful" or anything that I dislike about it Review collected by and hosted on G2.com.

The ability to sync db changes down to entity framework models. Review collected by and hosted on G2.com.

I need more control over data types. For example, we have a number of 1 digit database columns and they automatically get converted into boolean during sync. I know there is a way to prevent that, i just have not found it yet. Review collected by and hosted on G2.com.

I like it because it is faster than other connectors Review collected by and hosted on G2.com.

I use to connect to oracle my .netApp it works ok, but I have not exploited it in all its functions Review collected by and hosted on G2.com.

I have worked in .NET development for about a decade, and frequently connect to Oracle databases. The drivers Oracle provides are very problematic, and prone to connection error and corruption. Whenever using the Oracle-provided drivers, my teams have struggled regularly with the whole Schema becoming invalidated, failure to connect, and other issues. With Devart-it always "just works". The ability to do a direct connection is invaluable. I literally have never had an issue in connecting or with the schema failing to build or any other issue. Review collected by and hosted on G2.com.

Nothing, it is a great product. No drawbacks. Review collected by and hosted on G2.com.

1) Direct mode is very useful, has support for many needed Oracle features.

2) dbMonitor is helpful in diagnostic

3) Regular updates are also cool Review collected by and hosted on G2.com.

Entity Developer is not helpful for our development Review collected by and hosted on G2.com.