Home > web development > Is EF4 mature enough with MySQL or Oracle?

Is EF4 mature enough with MySQL or Oracle?

July 3Hits:1

Is Entity Framework 4 with MySQL or Oracle mature enough to be used on production level web application?

Can it provide high level of performance, or should we stick with just plain data access with SqlCommand?


The short answer with MySQL is yes, but there are things you should keep in mind:

  1. If you are starting a new project, it's a good idea to use EF4, but if you are going to use in an existing project, you should stick with what you are using now;
  2. Sometimes you will have difficult to find answers for a few problems you may find, there's not a lot of people using it;
  3. The Net/Connector improved a lot since a couple of years ago, so don't be scared if you look around and find people saying bad things about it;

I'm using with SQLite and with MySQL and it works great.

As for Oracle, they are working on an official Entity Framework adapter, which they say is expected to release production status at the fourth quarter of 2011.

no it isn't mature enough at all. When someone solves the problem with cross-apply queries being generated, then you can start thinking of checking whether performance issues were resolved too. (ie if EF generates a cross-apply type of query, it simply fails to run on Oracle or MySql, or any non-SqlServer DB for that matter).

Performance: EF4 is supposed to be better, but EF3 created truly awful sql for our legacy schema.

If you want to use an ORM there are others that do not have this limitation and some that perform better.

Related Articles

  • Is EF4 mature enough with MySQL or Oracle?July 3

    Is Entity Framework 4 with MySQL or Oracle mature enough to be used on production level web application? Can it provide high level of performance, or should we stick with just plain data access with SqlCommand? --------------Solutions------------- Th

  • SQL server Vs MySql vs Oracle for a large government project September 12

    I am in charge of deciding which database to use for a big government project with: 100 Million records (estimated in one big table) Availability and data reliability is paramount. Performance not as important as availability and reliability. Table s

  • MySQL or Oracle Associate Certification?December 12

    I have 15+ years in software development and 7+ in web development, and I want to get a certification in another area, like DBA. I have 7+ years of experience like MySQL developer. Which is better for certification? MySQL or Oracle 11g? Which of the

  • Synchronizing data between MySQL and Oracle databases? February 21

    I want to sync data between Oracle & MySQL databases. What is the best possible way to achieve this? Are there any tools/software available? This is not a one-time but an ongoing operation. The data set is also quite large, containing almost 300 tabl

  • Moving Drupal database from MySQL to OracleNovember 30

    I've developed a website with Drupal 7 running on standard PHP/MySQL server. Now there's a need to move it to server with Oracle database. While I managed to set up testing environment with a fresh Drupal 7 install and all my modules, to check if the

  • How To Sync Mysql With OracleJanuary 2

    i ask for help i have 2 oracle servers in my org and i wold like to sync the data(real time replication) to mysql each server to mysql DB i search for tech guide for dummy and i cant find please help --------------Solutions------------- take a look a

  • Mysql to Oracle communicationMay 17

    I have a website running with php and mysql on Centos(Amazon instance). The newly brought ERP(to be integrated with existing system) uses Oracle as db(located on a separate Windows Server). The orders from the website are inserted into the Master Mys

  • Does ODBC require any run-time software beyond an .exe file to run against MySQL and ORACLE SQL? September 15

    I'm writing a software [under Windows] in C++ which later needs to be able to connect to both MySQL and ORACLE SQL. Now the software needs to be as simple for the user as possible. Now I'm considering using ODBC. If I use ODBC, does the software late

  • MySQL for Oracle DBADecember 13

    I am a newbie to MySQL, but understand Oracle databases well. I need a quick help to understand the architectural differences. Currently I am working on a Windows platform. 1) In Oracle we have to put the database in archive log mode, do we have to d

  • Syinc databases mySQL to OracleDecember 25

    I'm new in "databaase administration" the problem I am facing is that I want to have an exact copy of a table, from MySQL database (website database) to oracle database (a local one). What I've done till now Searched for two days. I installed My

  • Doctrine2: How to change from MySQL to Oracle database

    Doctrine2: How to change from MySQL to Oracle databaseJanuary 26

    Initially, I started to develop a web application using Zend Framework 2 and Doctrine2 with MySQL but the customer wants that the database would be Oracle. So, I have to change the database from MySQL to Oracle. To do that, I have modified my doctrin

  • MySQL, SQLServer, Oracle, Postgree, CouchDB, MongoDB, Cassandra or SQLite? August 28

    Who database engine is better, in performance and usability? --------------Solutions------------- In case of webmasters choosing shared hosting, the database available to you from hosting service is dependent on their choice. Most likely MySQL and Po

  • SQL keyword difference between MySQL and Oracle 10g?September 17

    Good afternoon, Are there differences between Oracle 10g and MySQL with the CREATE, ALTER, DROP, REF, PRIMARY KEY, FOREGIN KEY and attribute variable type keywords? The reason I ask, is I'm planning to use MySQL WorkBench to generate the SQL for Orac

  • Which Database to choose: MySQL or OracleJanuary 30

    I have an application generating time series data (32 channels, 22KHz, 6 secs) once a minute. These have to be stored in a database. At the moment I'm using MySQL with InnoDB tables (file_per_table,file_format=Barracuda). As the data can be compresse

  • Installing multiple versions of MySQL on Oracle LinuxApril 16

    I have a Oracle Linux 5 server. I have to install MySQL 5.1 as well as MySQL 5.6. Is it possible to install both version of MySQL on the same machine? If yes, how can I achieve this? --------------Solutions------------- The program that can accomplis

  • Can I install MySql and Oracle 10g both Databases in same machine? July 9

    I have MySql Installed in my windows 7 machine and PHP on IIS. Now i need Oracle 10g anyway.I'm having king of dilemma to install Oracle 10g. If i can do so please suggest necessary steps and connection with PHP. Any help, recommendation, suggestion

  • Installing apr-util-mysql on Oracle Enterprise Linux 7.1August 4

    I have a server running Oracle Enterprise Linux 7.1 which is basically the same as RedHat Enterprise Linux. Apache is not starting because it says Can't load driver file apr_dbd_mysql.so On my CentOS 7.1 server I was able to fix this by installing ap

  • is there a way to connect to mysql using oracle sqlplus instant clientSeptember 16

    i am stuck while trying to connect to mysql using sqlplus client and i have already asked this question at askubuntu.com as http://askubuntu.com/questions/674871/not-able-to-connect-to-mysql-database-from-oracle-sqlplus-instant-client-in-ubun please

  • When i change my teacher project which use mysql to oracle has find some problems January 19

    This is one really trying my patience. I have a simple Spring 3.1 + Jersey application that I'm trying to work with ojdbc6.jar as my datasource. Unfortunately, no matter what I try, it can never find "oracle.jdbc.driver.OracleDriver" class. I ha

  • How to install Mysql on oracle Virtual box which has Opensuse OSDecember 17

    We have an open suse image on Virtual Box, which doesn't have mysql libraries. Can we install mysql libraries onto that image ? If so how ?? Please Help.. --------------Solutions------------- You can install it with yast2 or yast GUI: yast2 -i mysql

Copyright (C) 2017 ceus-now.com, All Rights Reserved. webmaster#ceus-now.com 14 q. 0.473 s.