Simple Query please help

Question

I want to Create simple Insert, Update, Delete (CRUD) using MySQL in Asp.net MVC.   i repeat using MySql not SQL (Sql server).   Thanx

Manav Pandya · Accepted Answer

Hello   Connectivity of MYSQL with MVC is as simple as we do with SQL Server   But for MYSQL we need to use mysql installer for that , you can download mysql installer from below link :   https://dev.mysql.com/downloads/installer/   And for complete CRUD operation you can follow few articles :   Video :   https://www.youtube.com/watch?time_continue=155&v=Col_2RDI3_4   Articles step by step :   https://www.c-sharpcorner.com/UploadFile/asmabegam/Asp-Net-5-crud-for-mysql-using-sp-and-helper-class/   https://www.aspsnippets.com/Articles/ASPNet-MySQL-CRUD-Select-Insert-Edit-Update-and-Delete-in-GridView-using-MySQL-database-in-ASPNet.aspx   https://dzone.com/articles/crud-operation-with-aspnet-core-mvc-using-visual-s   https://www.codeproject.com/Tips/522619/Implementing-CRUD-operations-in-MySQL-using-Entity   I hope above links will help you   Thanks

Ketan Mokariya · Answer

This youtube video can help you to create CRUD operation using entity framework.      https://www.youtube.com/watch?v=Col_2RDI3_4   Regards, Ketan

Kaushik Dhameliya · Answer

Hello Rajesh   You can use MySQL entity framework same sql   Follow below url   https://dev.mysql.com/doc/visual-studio/en/