any SQL levelling features across the providers?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
TheRhinoDude
Posts: 6
Joined: Thu 30 Apr 2009 22:59

any SQL levelling features across the providers?

Post by TheRhinoDude » Tue 05 May 2009 18:12

One of your competitors DataDirect provides roughly a half-dozen interoperability features of their support providers, such as ODBC escapes, parameter markers, consistent ErrorCollection impl, error code mapping, Oracle ref cursors, and arrays of parameters. For more info you can read this:

http://www.datadirect.com/developer/net ... bility.pdf

There is also a good bit of SQL up-levelling going on:

http://www.datadirect.com/developer/doc ... veling.pdf

Several of these make cross-vendor ADO.Net code much cleaner and easier to write and maintain, in particular the escapes, markers, and error enhancements.

Which if any of these are implemented across the dotConnect suite?

Thanks,
Ryan

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

Post by Shalex » Wed 06 May 2009 15:39

dotConnect for Oracle has a built-in powerful modeling and code generation tool for LINQ to SQL and ADO.NET Entity Framework (Entity Developer, http://www.devart.com/entitydeveloper/ ), an advanced design time support (OracleSqlDataTable, DataSet Wizard, DataSet Manager), handy SQL execution monitoring (OracleSqlMonitor), high performance, regular new builds with bug fixes and new functionality implementation, expedited individual assistance with dotConnect for Oracle-related questions from the dotConnect for Oracle developers themselves, etc.

For more information, please refer to our online documentation: http://www.devart.com/dotconnect/oracle ... tures.html .

If you are interested in creating cross-database applications, please learn more about UniDirect .NET that offers universal access to data of different databases for the Microsoft .NET Framework. It supports most of major database servers, including Microsoft SQL Server, Microsoft Access, Oracle, DB2, MySQL, PostgreSQL, InterBase, and Firebird. Other servers can be accessed through their ADO.NET, OLE DB and ODBC providers.

For example, pay attention to the UniSQL features that are implemented in UniDirect .NET: http://www.devart.com/unidirect/docs/?using.html , the UniSQL part.

TheRhinoDude
Posts: 6
Joined: Thu 30 Apr 2009 22:59

Post by TheRhinoDude » Wed 06 May 2009 17:45

I did check it out, but UniDirect.Net isn't up to date with the latest dotConnect providers. Any eta on this?

Thanks,
Ryan

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

Post by Shalex » Thu 07 May 2009 09:37

Please refer to this thread at our forum: http://www.devart.com/forums/viewtopic.php?t=14756 .

Post Reply