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:[EMAIL PROTECTED] 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 :-) ---------------------------------------------- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
