-
Since Oracle are deafeningly silent on the matter, currently the best way is to use a third party provider. I keep hearing good things about Devart dotConnect . You could also check out the open source dbLinq or LinqToOracle
-
If you're doing development against an Oracle database, you can use the built in Oracle client, System.Data.OracleClient. However this is a bad idea for a two reasons: It will be deprecated in .NET 4.0 Oracle's provider, ODP.NET is better in several ways: Faster Supports more Oracle features...
-
A few months ago when I was working with Oracle in a data warehouse, I came across hints . Basically these are statements in the below form /*+ hint */ /*+ hint(argument) */ /*+ hint(argument-1 argument-2) */ placed inside your query to manipulate the oracle optimizer to optimize a query's execution...