Oracle .NET Release

In case you missed an important news, Oracle just released ODAC 12c Release 3 to production.  The new ODAC release is now available for download from OTN. New features include Entity Framework 6, Code First, Code First Migrations, .NET Framework 4.5.2 certification, and managed ODP.NET XML DB, Kerberos, and more streamlined distributed transaction support. Try …

Continue reading ‘Oracle .NET Release’ »

Truncate All Tables in Oracle and SQL Server

I was working with another developer today, and he wanted to experiment and see if running Entity Framework generator on a blank database takes longer than the one with a lot of data.  We wanted to truncate all the tables.  You cannot truncate a table with that participates in a foreign key constraint.  SO, together …

Continue reading ‘Truncate All Tables in Oracle and SQL Server’ »

Connecting to Oracle from SQL Server

I wanted to query some Oracle data from the SQL Server Management Studio today and issue some updates as well.  After trying many, many things I finally was able to get the connection to work.  I wanted to document the exact steps here, mostly for myself. You have to add a linked server into SQL …

Continue reading ‘Connecting to Oracle from SQL Server’ »

Oracle ODAC / ODP 12c Uninstall

A few months ago when I reimaged my machine, I installed Oracle 12c with the latest ODP/ODAC.  It worked great, but only one pluggable database is supported for development.  I decided to uninstall and go back to 12g along with ODAC and ODP.  All worked smoothly, until I tried to connect to Oracle database. Then …

Continue reading ‘Oracle ODAC / ODP 12c Uninstall’ »

Oracle Data Provider 12c Release

It seems that I have not seen much chatter related to the recent release of Oracle Data Provider version 12 c.  I feel that it marks an important milestone in Oracle /.NET story.  Finally Oracle has a provider version that is written in fully managed .NET code.  What does this mean you ask?  Most importantly, …

Continue reading ‘Oracle Data Provider 12c Release’ »

Workaround for Non-Unicode Parameters in Entity Framework with Oracle

I ran into a very interesting problem this week.  I got feedback that a few queries in an application I am working on are not using indexes.  The app itself is using Entity Framework over Oracle.  There was a matching index for each query, but Oracle was not using it.  I decided to use Toad …

Continue reading ‘Workaround for Non-Unicode Parameters in Entity Framework with Oracle’ »