Visual Studio 2015 and Mysql Database

Question

Hi Guys....... !

I have to do a project in Visual Studio 2015 using mysql database. I have already installed everything and I am able to see the databases in the server explorer after opening Visual Studio 2015. The mysql connector am using is mysql-connector-5.3.4-win32 which I downloaded from mysql website

What I am now looking for is a simple program to insert, update, retrieve and delete data from a Database. I need the code to do that and all other necessary pieces of information to run this successfully.

Any help will be highly appreciated.

Thanks in Advance

Answer 1

Try out the Entity Framework

http://www.codeproject.com/Tips/426790/Using-MySQL-with-Entity-Framework

I haven't explicitly tried this with Visual Studio 2015, but I suspect it will work just fine.

Answer 2

Hi Alpha-Blaze,

I recommend you to learn more about Entity Framework, because it is very hepful and easy to implement in Visual Studio 2015 version. Entity Framework (EF) is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write.

More informations: https://msdn.microsoft.com/en-us/data/ef.aspx

Best regards!
(It this was helpful propose it as an answer)

Answer 3

Hi Alpha-Blaze,

Thank you for posting in MSDN forum.

This forum is discuss about Visual Studio Setup and Servicing.

As your issue is related to Ado.net, I help you move this case to  Ado.net  forum for dedicated support.

Thank you for your understanding.

Best Regards,

Wen Xu

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.

Click HERE to participate the survey.