Using MySql with Entity Framework 4 and the Code-First Development CTP

by

Right, finally got it working with a few points of interest.

  • Cannot create a DB, must exist already
  • You have to create a connection string for each DB contest using the DBContext name (in the above example a connectionstring must exist with the name “NerdDinners”), not just a default one (else it will use SQL)
  • It will use the name of the DBSet name you use to define your context as the name of the table, so be careful when naming them.

All in all, a long road but there in the end

**Update
Another point to note, when deploying your MVC site using MySQL you will most like need also add a DataFactory to your web.config.
Usually because of the difference in MySql connectors out there and the versions of MySQL that are supported.
(answer found through other sources after much head scratching)
Just add:

  <system.data> 
    <DbProviderFactories> 
      <add name="MySQL Data Provider"
           invariant="MySql.Data.MySqlClient"
           description=".Net Framework Data Provider for MySQL"
           type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.3.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" /> 
    </DbProviderFactories> 
  </system.data>

As a seperate section to your web.config making sure to set the version number of the MySQL.Data.dll you deploy with the site (also a good idea to “copy as local” your MySQL DLLs to ensure compatibility.

More Related Contents:

  1. How do I setup ASP.NET MVC 2 with MySQL?
  2. SQL select only rows with max value on a column [duplicate]
  3. What is the error “Every derived table must have its own alias” in MySQL?
  4. Generating Depth based tree from Hierarchical Data in MySQL (no CTEs)
  5. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  6. How to pivot a MySQL entity-attribute-value schema
  7. Generating a series of dates [duplicate]
  8. MySQL find_in_set with multiple search string
  9. Oracle Database Link – MySQL Equivalent?
  10. How to escape single quotes in MySQL
  11. MySQL comparison with null value
  12. Unique constraint that allows empty values in MySQL
  13. How to select from two tables in MySQL even if not all rows in one table have corespondents in the other?
  14. Restoring deleted ‘root’ user and password for MySQL
  15. INTERSECT in MySQL
  16. MySQL select with CONCAT condition
  17. mysql field name from variable
  18. Multiple select statements in Single query
  19. MySQL SELECT LIKE or REGEXP to match multiple words in one record
  20. Syntax error when using except in a query
  21. Convert Unix timestamp into human readable date using MySQL
  22. Why the order of evaluation for expressions involving user variables is undefined?
  23. Easiest way to copy a table from one database to another?
  24. sql like operator on integer
  25. The best way to remove value from SET field?
  26. MySQL matching unicode characters with ascii version
  27. Equivalent of MSSQL IDENTITY Column in MySQL
  28. Update multiple rows with multiple ‘where’ clauses for each individual row
  29. WHERE datetime older than some time (eg. 15 minutes)
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment