Page 1 of 1

any SQL levelling features across the providers?

Posted: Tue 05 May 2009 18:12
by TheRhinoDude
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

Posted: Wed 06 May 2009 15:39
by Shalex
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.

Posted: Wed 06 May 2009 17:45
by TheRhinoDude
I did check it out, but UniDirect.Net isn't up to date with the latest dotConnect providers. Any eta on this?

Thanks,
Ryan

Posted: Thu 07 May 2009 09:37
by Shalex
Please refer to this thread at our forum: http://www.devart.com/forums/viewtopic.php?t=14756 .