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 …
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’ »
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 …
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, …
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’ »