| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> AW: Experiences with Oracle and MS .Net data providers
Hi
Some coworkers implemented an application using C# and the MS .NET provider
for Oracle (9.0.1 DB).
One thing I can remember: Mapping C#'s float datatype to Oracle FLOAT (or
NUMBER(...)) somehow didn't work that great.
Another thing was that they could not use transaction processing via the
underlying COM+ components correctly. Something with the threading went
wrong. It did work though for SQL*Server, so they assumed the MS provider
for Oracle screwed up.
Switching to the Oracle provider wasn't an option anymore either, since the
interfaces weren't 100% compatible.
I don't know about that since I don't know .NET, but I was surprised that that could be the case. I thought it would work like in Java, where the JDBC driver supplier "just" implements a certain set of interfaces. If you don't downcast an ResultSet into for example an OracleResultSet and stick to the methods the standard inteface provides, ... no probs. How is it, that data providers can be in incompatible in .NET ?
Stefan
-----Ursprungliche Nachricht-----
Von: Grant Allen [mailto:Grant.Allen_at_towersoft.com.au]
Gesendet: Dienstag, 25. November 2003 06:59
An: Multiple recipients of list ORACLE-L
Betreff: Experiences with Oracle and MS .Net data providers
Hi all,
Would really like to hear any feedback regarding anyone comparing these two .Net data providers (or even some of the others out there - Datadirect, etc.).
We're at decision making time, and things like the differences in calling stored procs, returning Ref Cursors, are starting to mean we need to pick one. My gut says go with the Oracle one (keep the technology stack based on the one vendor), but they kludge too many things. (just like in ADO, where they ignored the standard for stored proc calling).
Anyway, any comments about your use, likes and dislikes of either would be much appreciated.
Ciao
Fuzzy
:-)
If swallowed seek medical advice
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Grant Allen
INET: Grant.Allen_at_towersoft.com.au
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stefan Jahnke
INET: Stefan.Jahnke_at_bov.de
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Nov 25 2003 - 06:39:30 CST
 |
 |