SQL differences between SqlServer and Oracle

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for universal data access
Post Reply
janvv
Posts: 1
Joined: Tue 07 Dec 2004 19:16

SQL differences between SqlServer and Oracle

Post by janvv » Tue 07 Dec 2004 19:30

I have an application which should be working with SqlServer and Oracle.
Why do I need Unidirect? Isn't it the same as using the interfaces IDBConnection and IDBCommand?
Or does it solve Sql differences?
A query like 'select * from sometable where somedatecol < getdate()' will only work with SqlServer, and 'getdate()' should be replaced by 'sysdate' to make it work with Oracle. And this is only a simple issue. How about other sqlcommands like 'update tblA set a.col1 = b.col3, a.col2 = b.col from tblA as a, tblB as b where etc...'. This will never work on an Oracle database. Even using a UniCommand I cannot have a common sourcecode for both databases. Or don't I understand the Unidirect product?

Oleg
Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Re: SQL differences between SqlServer and Oracle

Post by Oleg » Wed 08 Dec 2004 12:15

UniDirect .NET doesn't solve problems with different ways of writing SQL now.
But UniDirect .NET offers the following features:
  • Universal access to data of different databases
  • 100% managed code
  • High performance
  • Easy to deploy
  • UniScript component to execute scripts
  • Ability of monitoring query and stored procedures execution
  • Advanced design-time editors
  • Migration wizard from SQL Server, OLE DB, ODBC and Oracle .NET Data Providers
  • Help integrated into Visual Studio .NET
  • Free support for registered users
  • Licensed per a developer without royalty fee

chrissilein

Re: SQL differences between SqlServer and Oracle

Post by chrissilein » Mon 13 Dec 2004 21:12

Hello,

do you plan to release such a component?
Are there any components which solve these
language issues??

Chris

Oleg
Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Re: SQL differences between SqlServer and Oracle

Post by Oleg » Tue 14 Dec 2004 08:53

We are planning to enhance UniDirect .NET functionality in future and will add the feature with an ability of different writing of SQL but not at the nearest time.

Guest

Post by Guest » Fri 17 Dec 2004 17:12

Hi janvv,

as I have the same problem as you. What do you plan to do?
Pls, send me an email (chris1769@gmx.de).

Best regards,

Chris

Post Reply