From SQL Server to Oracle using Entity Framework with code-first Migrations

Question

I'm was told recently that in our current project we have to use Oracle instead of SQL Server.

I need some help to make it work. I've already installed Visual Studio ODTwithODAC but when I try to run the command update-database in the Package Manager Console, the following error is thrown:

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.

I know that the problem is not the access to DB because I could connect to it via Server Explorer and I took the connection string from it.

My connection string goes like this:

<add name="LpssContext" 
     connectionString="SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.1.106)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)));uid=sys;pwd=sys;" 
     providerName="System.Data.OracleClient" />

Any ideas about what's wrong?

Does Oracle support code-first migrations?

I think your providerName should be something else than System.Data.SqlClient — Alexandre Rondeau
– Alexandre Rondeau, Commented Oct 7, 2013 at 19:16
The provided connection string and message was updated. SqlClient won't work because this is Oracle. EntityClient didn't work — Pato Loco
– Pato Loco, Commented Oct 7, 2013 at 19:21
As far as I know Oracle doesn't support code-first: forums.oracle.com/thread/2558851 — Thiago
– Thiago, Commented Oct 7, 2013 at 19:39

Pato Loco · Accepted Answer · 2014-02-11 14:28:00Z

1

Currently there's no support for CFM with Oracle connector. There's a paid connector that support it though, http://blog.devart.com/entity-framework-code-first-migrations-support-for-oracle-mysql-postgresql-and-sqlite.html

The other option is to change your db layer to DB First (with lots of work) manually, as I finally did

answered Feb 11, 2014 at 14:28

Pato Loco

1,2441 gold badge14 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

From SQL Server to Oracle using Entity Framework with code-first Migrations

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related