How to use Oracle Entity Framework with no config file

entity-framework entity-framework-6 odp.net oracle

Question

Is it possible to create a code-first Entity Framework model that connects to an existing database using ODP.Net without having any settings in the app.config file?

I have tried many different things.

Currently I am setting DbConfiguration:

    sealed class EntityFrameworkConfiguration : DbConfiguration
    {
        public static readonly DbConfiguration Instance = new EntityFrameworkConfiguration();

        EntityFrameworkConfiguration()
        {
            this.SetDefaultConnectionFactory(new OracleConnectionFactory());
            this.SetProviderServices("Oracle.ManagedDataAccess.Client", EFOracleProviderServices.Instance);
        }
    }

    DbConfiguration.SetConfiguration(EntityFrameworkConfiguration.Instance);

I am passing an OracleConnection directly into the EF context.

However, I either have problems with the SQL being generated in SQL Server format (using double-quotes around table aliases), or I get the following error:

An unhandled exception of type 'System.NotSupportedException' occurred in EntityFramework.dll

Additional information: Unable to determine the provider name for provider factory of type 'Oracle.ManagedDataAccess.Client.OracleClientFactory'. Make sure that the ADO.NET provider is installed or registered in the application config.

Has anyone any experience of getting this to work without polluting app.config with crud?

1
3
9/6/2015 10:57:27 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Uff. Found the problem.

Because I was registering column mapping using lower case the query didn't work. The column and table names must be in upper-case.

How silly.

1
9/7/2015 11:45:46 AM

Popular Answer

Yes. To complete the switch from machine.config/app.config to code-based configuration, I had to also include a call to SetProviderFactory().

public sealed class EntityFrameworkConfiguration : DbConfiguration
{
    public static readonly DbConfiguration Instance = new EntityFrameworkConfiguration();

    public EntityFrameworkConfiguration()
    {
        SetDefaultConnectionFactory(new OracleConnectionFactory());
        SetProviderServices("Oracle.ManagedDataAccess.Client", EFOracleProviderServices.Instance);
        SetProviderFactory("Oracle.ManagedDataAccess.Client", new OracleClientFactory());
    }
}

I also called DbConfiguration.SetConfiguration(EntityFrameworkConfiguration.Instance); in the startup of my application because I had DbContext's in multiple assemblies that all needed to share this configuration.

On a side note, I have also found this to be effective in allowing your application to work around the ConfigurationErrorsException: The 'DbProviderFactories' section can only appear once per config file for cases where you may not have access to repair the user's machine.config.

Benjamin Brandt

Related Questions

web configuration file for entity framework

The problem is with the Integrated Security parameter. When it is set to True, .Net try to open the connection with the current user event if you specify a user and password. So to open the connection with a specific user, set the Integrated Security to False and it will work....<connectionStrings> <add name="EFDbContext" connectionString="Data...
asp.net asp.net-mvc entity-framework
asked by Stephan

Entity Framework DbContext Connection string not seen in app.config/web.config

So, I have followed this instruction from ADO.NET team blog to try to make a small test project. I have double-checked everything. It doesn't seem to work and keeps saying connection string is missing....http://blogs.msdn.com/b/adonet/archive/2011/03/15/ef-4-1-model-amp-database-first-walkthrough.aspx...Step. 1 Build this UserModels.dll. In the dll...
database-first dbcontext ef-code-first entity-framework
asked by Tom

How to specify Entity Framework Code First connection string in external Enterprise Library config file

Based on the config files supplied, Entity Framework went looking in app.config of root in start project and didnt find the EF content. Especially the Connection string. When you first used UF it would have created such entries, perhaps in the model project. IM using EF5.0 so careful with cut and paste on Entity Section ....<configuration> <con...
code-first connection-string database enterprise-library entity-framework
asked by phil soady

Entity framework 6 without config file?

I have an application that can not use a config file and has to set up the connectionstring for the entity context by code (with EntityConnectionStringBuilder)....The problem comes however with this:...No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlClient'....Since I can not use the standard app.conf...
entity-framework
asked by Jens

Oracle ODP.Net With Entity Framework 6 - Entity framework database compatible provider could not be found

I am trying to build an MVC 5 Web application with Entity Framework 6 that works on Oracle Database , am trying to use ODAC 12c Release 3 which includes support for Entity Framework 6 Code First and Code First Migrations; NuGet, .NET Framework 4.5.2; and ODP.NET, Managed Driver XML DB. As per ...http://www.oracle.com/technetwork/topics/dotnet/whats...
.net ado.net-entity-data-model entity-framework odac oracle
asked by Wasef Anabtawi

Facing Issue while connecting Entity framework with Oracle 11g using MVC 4

You have to give a proper assembly qualified name. ...If you are not sure of it, you can check what the name is using AssemblyName.GetAssemblyName(@""). And copy it to your config....For more information, see ...https://msdn.microsoft.com/en-us/library/2exyydhb(v=vs.110).aspx...I had faced the exact same error. This solution worked fine.
asp.net-mvc-4 entity-framework entity-framework-6 oracle oracle11g
asked by Ratna Aloorkar

ADO.NET Entity Framework - Oracle with Entity Framework 6

You have to install 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio. ... You can download it from ...Oracle... web site.
asp.net-mvc entity-framework entity-framework-6 oracle
asked by Bazaleev Nikolay

How to Add/Activate "Oracle.ManagedDataAccess.Client" in the EF 6 provider config file?

I got the answer from ...an Oracle's ODP.Net document... and ...an Oracle Community forum...:...Apperantly, according to the accepted answer, until early 2014, the EF 6 is not supported by ODAC as stated in its ...document.... One must partially use EF 5 to work with ...Oracle.ManagedDataAccess...When I checked the document that the accepted answer...
asp.net-mvc c# entity-framework odp.net oracle-manageddataaccess
asked by Ian

Calling Oracle stored procedure using Entity Framework with output parameter?

In this case, you shouldn't be calling:...var query = ctx.Database.SqlQuery<CmdRegisterAssetDto>(sql, projectNameParam, countryCodeParam, locationParam, assetRegisteredParam); ...But instead be calling:...var result = ctx.Database.ExecuteSqlCommand(sql, projectNameParam, countryCodeParam, locationParam, assetRegisteredParam); ...Notice that the onl...
c# entity-framework entity-framework-6 oracle oracle-manageddataaccess
asked by Jeff

How can I prepare WITH CLAUSE using Oracle .Net entity framework queries

If I understood the problem, it is that you can't use the ...WITH... factoring clause. If that's so, move the ...EVENTS... CTE into the ...FROM... clause:...select * from (select * from EVENTS_ATCS WHERE ROWNUM <10) A --> this is EVENTS LEFT JOIN ATCS_EVENT_MASTER B ON (A.TYPEID = B.EventId) AND ((A.BYTE1 >= B.GE_BYTE1 AND A.BYTE1 <= ...
common-table-expression entity-framework entity-framework-6 oracle
asked by Littlefoot

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow