There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?

1

Closed

Issue with Oracle and Entity Framework

description

Hi All,

I'm working on small POC( Entity Framework with Oracle) and I'm getting below error
"A null was returned after calling the 'get_ProviderFactory' method on a store provider instance of type 'System.Data.OracleClient.OracleConnection'. The store provider might not be functioning correctly."

file attachments

comments

Which Oracle provider are you using (if any - this seems like none was installed). Also, I don't think that Oracle EF provider from Oracle supports Code First yet (I don't know about the provider from Dev Art).

This kind of problems can be probably resolved quicker when asked on stack overflow as this does not seem to be an issue with EF.

System.Data.OracleClient is an ADO.NET provider but is not an EF Provider. In addition it has been deprecated since .NET Framework 4 (http://msdn.microsoft.com/en-us/library/77d8yct7.aspx).
The customer needs to use an EF enabled ADO.NET provider that supports Code First (I believe ODP.NET does not support Code First at the moment, I don't know about DevArt's Oracle provider).