You may have issues with it, as I haven't written an oracle specific provider (either using the Microsoft provider or the Oracle one) so the only access will be via ODBC.
The SQL generated for the ODBC driver is based on ANSI sql so there may be some syntax issues that arise with Oracle.
I'm more than happy to knock up an Oracle specific database provider using the Microsoft ADO.NET driver. It's a simple process and should only take an hour or so to do, but I'd have to rely on you to test it properly since I don't have an Oracle database.
- Richard.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
Does anyone use it with Oracle DB in a large scale system?
Am I going to get in to truoble when using it with Oracle?
Oren
Hi Oren,
You may have issues with it, as I haven't written an oracle specific provider (either using the Microsoft provider or the Oracle one) so the only access will be via ODBC.
The SQL generated for the ODBC driver is based on ANSI sql so there may be some syntax issues that arise with Oracle.
I'm more than happy to knock up an Oracle specific database provider using the Microsoft ADO.NET driver. It's a simple process and should only take an hour or so to do, but I'd have to rely on you to test it properly since I don't have an Oracle database.
- Richard.