1

I wonder the simplicity of working with Microsoft SQL database server with .NET Entity Framework. Is there a possible way to use it with Oracle & MySQL database servers?

Muneer
  • 7,384
  • 7
  • 38
  • 62

3 Answers3

1

You could use another ORM, like NHibernate which supports Microsoft SQL, Oracle, and MySQL, among many others.

If you want/need to stick with EF, there are already questions on SO about using it with MySQL and with Oracle.

Community
  • 1
  • 1
R. Martinho Fernandes
  • 228,013
  • 71
  • 433
  • 510
  • is NHibernate database independent? – Muneer Jun 27 '11 at 10:19
  • @Muneer: Pretty much, yes. It supports all the database servers [mentioned here](http://nhforge.org/doc/nh/en/index.html#configuration-optional-dialects) (that list is a bit outdated, because it does support the most recent versions of SQL server and Oracle, even if they're not mentioned there). – R. Martinho Fernandes Jun 27 '11 at 10:25
  • Great; Let me have a look on it. – Muneer Jun 27 '11 at 12:11
1

Oracle Data Access Components for .NET (http://www.oracle.com/technetwork/topics/dotnet/downloads/oracleefbeta-302521.html) includes also Oracle Data Provider for .NET 4 11.2.0.2.40.

A nice tutorial how to use Model-First approach can be found at http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/dotnet/EntityFrameworkOBE/EntityFrameworkOBE.htm.

Good luck,

LM

John
  • 11
  • 1
0

A list of Oracle providers for Entity Framework can be found here:
Comparison of Entity Framework compatible providers for Oracle?

And for MySQL these are available:
http://www.mysql.com/products/connector/
http://www.devart.com/dotconnect/entityframework.html
http://uda.openlinksw.com/dotnet/

Community
  • 1
  • 1
Danny Varod
  • 17,324
  • 5
  • 69
  • 111