Entity Framework Code First and MySQL Stored Procedure
EF code-first approach expects that there is no logic in the database. That means no stored procedures and no database views. Because of that code-first approach doesn't provide any mechanism to generate such constructs automatically for you. How could it do that if it means generating logic?
You must create them yourselves in custom database initializer by manual executing creation scripts. I don't think that this custom SQL constructs can be handled by SQL migrations.
https://msdn.microsoft.com/en-us/library/dn468673(v=vs.113).aspx
https://dzone.com/articles/how-to-use-stored-procedure-with-entity-framework
http://www.entityframeworktutorial.net/stored-procedure-in-entity-framework.aspx
http://www.dotnetodyssey.com/2015/03/12/calling-stored-procedure-from-entity-framework-6-code-first/
https://sunali.com/2012/10/10/querying-mysql-using-entity-framework-and-mysql-stored-procedures/
https://dotnetthoughts.net/how-to-execute-a-stored-procedure-with-entity-framework-code-first/
https://www.mikesdotnetting.com/article/299/entity-framework-code-first-and-stored-procedures
