Entity Framework change Schema Name at runtime
I stumbled on this very good method to deal with this painful limitation in ODP.NET. I use this inconjunction with pulling the paramters from the app.config and using System.Data.EntityClient.EntityConnectionStringBuilder and Oracle.DataAccess.Client.OracleConnectionStringBuilder.
I can run against multiple schemas without all the hassles.
http://stackoverflow.com/a/15248768/2426146
Hopre this is helpful to others who have suffered with this limitation!