MySQL Entity Framework code first migrations - bugs or PEBCAK?
Posted by: Harald Sømnes Hanssen
Date: December 17, 2016 12:45PM

Thought I try out MySQL with Entity Framework and code first, however, it is not as straight forward as I thought.

First off: Setup is really annoying. It is not straight forward, even with the tutorial from MySQL.


Secondly, not everything is supported.
Altering a table through migrationg? Forget it, not implemented
Deleting a table through the migration tool? Not implemented either.
All of the features are lacking, are especially necessary during development, but are not show stoppers. It is a hassle though having to delete the database for every change you do ..


However, when I started dabbling with lists, I really started having problems.
For example, a person (an entity) is put into a list of another entity, the Person table will have overwritten all of the other entries in that table with one of the persons in the table. Which is weird.

My experiment is going on right here:
https://github.com/verzada/CrossfitOrganizer

The dbcontext object
https://github.com/verzada/CrossfitOrganizer/blob/master/src/CrossfitOrganizerDatabaseProvider/Database/CrossfitOrganizerDatabaseContext.cs

The class (usually 'a' class since I have to delete them along the way) for creating the tables with stored procedure
https://github.com/verzada/CrossfitOrganizer/blob/master/src/CrossfitOrganizerDatabaseProvider/Migrations/

I'm constantly reading tutorials (like this one https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework60.html) and often MySQL makes me feel stupid (such as not knowing that the database name is case sentitive in web.config).

My impression is that this technology is not ready.
Or I'm doing it the wrong way?

Options: ReplyQuote


Subject
Written By
Posted
MySQL Entity Framework code first migrations - bugs or PEBCAK?
December 17, 2016 12:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.