ASP.NET MVC 4 - MySQL Entity Framework Data First CRUD - Part 4

This video walks you through how to use the Entity Framework with MySQL Database (owned by Oracle) to perform basic CRUD Operations (Create, Read, Update, Delete).

Note: You MUST install the MySQL for Visual Studio first before you are able to use it as a data source. As of today Visual Studio 2010, 2012 and 2013 are supported by this software.

[Mattzard]

I have spent a number of hours trying to get this working. Thankfully I came across your video and my problems have been solved within 16 minutes! Thanks a lot for the help.

[edvaaart]

After some fiddling and some connection string workarounds i got the MySQL MVC 4 Code First working! Awesome stuff. Thanks again!

[edvaaart]

This is a really awesome video that shows that it can be done in a relatively easy way. Thanks for the great clarity, this helped me big time!!!

[milindnikam]

Hi saw your video on - ASP.NET MVC 4 - MySQL Entity Framework Data First CRUD - Part 4
It was very useful to understand the CRUD operation with MVC.

[hemanglunagaria]

Thank you DigiOz MultiMedia....it helped a lot while how understanding MVC and entity framework work with MySql

[pas]

Thanks so much for an informative and easy to follow tutorial!

[digioz]

Excellent. Glad you could make it work.

[ariellipschutz]

Very good video.
i have a problem.
After select the mysql datasource the dialog page "choose your database objects and settings" doesn't appear on program.
And the dialog just close!
And the model is not on the web config or in the folder.

Any ideaa?
Thanks

[UsmaanPro]

Where did you get that <system.data> code from? You just pasted it in without explaining where you got it from. How do I get me own PublicKeyToken? Please please explain.

[digioz]

The full source code is in the description right below the video, and it includes web.config file. Feel free to download and take a look at it.

[tcol]

Thanks dude, it was very informative.

[digioz]

Yes, that's called "Code First". I already have a video for that for MSSQL, but I will make one for MySQL as well time permitting.

[edvaaart]

Would it also be possible to have a MySQL DB and tables be created from a C#class definition by adding a specific connection string? I did the tutorial ASP.NET tutorial "Intro to ASP.NET MVC 4" where MS SQL tables are auto generated from C# class definitions. Would it also be possible to do this in MySQL?

Keep up the good work!

[MadCrevan]

Hi. Great video :) Bu i have one question: Do You know how to make this table sortable ?

[elamraniabouelassadzouhair]

... Thanks a lot man, that was very helpful.... i have a question though, first i was using Visual Studio 2013 Preview but i could'n find MySQL database in the " choose data source " dialog window, i even installed the latest version of MySQL connector as well as the windows MySQL installer (to get MySQL plugin for visual studio) but nothing changed, i had to get back to VS 2012 Ultimate, i just wanted to know if there is a special MySQL connector for the 2013 Preview Edition .

[ArthurDiasCaldeira]

Thanks for the excelent video...

but... I'm trying to do the same thing in a project and every time I tryed to connect with MySQL server (in localhost or remote host) The Visual Studio 2012 freezes and shutdown it.. I'm using the lastest version o MySQL .NET Connector (version 6.8.3)...

So... I have a question... What I'm Doing wrong???

Any way... thanks

[flywithnature]

Thank you very much ! very useful tutorial! Exactly what I was looking for!
I have got some more questions: what about deployment to a remote hosting provider? which one do you use for ASP.Net MVC and Web API technologies? Are there any good and cheaper alternatives to Azure?
I imagine I should change the database connection string, putting the remote database, right? and regarding the publication of the application itself? how to do it in a hosting service non-Azure?
Thank you

[sanchitanand]

So why do you create a schema folder and store your database in your solution? I am doing something similar except my database will constantly have new info coming in from a machine. I have to display this dynamic data.

[CoderHub]

its very nice ..but i have one Question how bind Complex type like store procedure in mysql

[UsmaanPro]

I don't have a MySQL database. I want to create a brand new one. How can I do this? Will I have to create one and then import it? What if I import it and then later decide to update it's fields etc.