@manhnguyenv

Welcome to my blog!

Entity Framework with MySql Stored Procedure

January 26, 2018 17:01

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://dev.mysql.com/

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.entityframeworktutorial.net/EntityFramework4.3/execute-stored-procedure-using-dbcontext.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

https://www.red-gate.com/simple-talk/dotnet/net-framework/using-entity-framework-with-an-existing-database-data-access/

Categories

Recent posts