Last post Mar 19, 2015 08:06 PM by jsiahaan
Mar 17, 2015 10:14 AM|jsiahaan|LINK
I'm struggling create Web API using MySQL. There is no problem when MVC using MySQL.
Any one give me references about Web API using MySQL please?
Mar 18, 2015 02:23 AM|Shawn - MSFT|LINK
Generally speaking, there is no difference between Web API and MVC when using mysql database.
For this scenario, you could refer to the following link for Implementing CRUD Operation in MySql Using Entity Framework:
Mar 18, 2015 03:12 AM|jsiahaan|LINK
Thanks Shawn - MSFT,
I have done CRUD successfully, or no problem with CRUD, the problem is when I create WebApi services. I've tried using MVC and WebAPI together and separately, both for API still unsuccessful.
No problem when create WebAPI using MS SQL Server. I've made two similar project one for MSSQL, one for MySQL. The problem only using MySQL.
Mar 18, 2015 07:43 PM|jsiahaan|LINK
Using Breeze to solve Web API has solved my requirement, but not solved the problem using Web API controller template. Due to my time constraint, I closed this case.
Mar 19, 2015 08:06 PM|jsiahaan|LINK
The problem was solved by setting "Lazy Loading" to "false". In my case it is on .edmx diagram properties.