Skip to main content

Entity Framework Code First and MySql on Azure

We have used Entity framework with SQL Servers mostly. In this blog post we are going to see how we can use Entity framework with MySql on Azure.

How to create MySql database on Azure:

On azure MySql is not maintained by Microsoft itself. It is provided their partner cleardb. So You need to search at Azure Market Place and then add it like below.

market-place-azure-my-sql-database


Once you click on and provide name of database it will start creating like below.

creating-my-sql-database

After sometime your database will ready to use.

How to use Entity Framework with MySql:

We are going to create a console application for the same like below.

console-application-for-entityframework-mysql

Once you are done with creating console application. It is time to add Nuget Package for Entity framework like below.

install-package-entity-framework

Once you are done with that It’s time to add MySql specific Nuget package to use MySql provider for entity framework. Following is a Nuget package for the same which will add all the required providers and files for Entity Framework to use it with MySql.

nuget-pacakge-for-mysql-entity

and Here’s how I have installed it.

mysql-entity-framework-nuget-package
Now it’s time to write code. Following is a Model class for Customer.
namespace EFWithMySQL
{
    public class Customer
    {
        public int CustomerId { get; set; }
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public string City { get; set; }
    }
}
And here is the my data context class.
using System.Data.Entity;

namespace EFWithMySQL
{
    [DbConfigurationType(typeof(MySql.Data.Entity.MySqlEFConfiguration))] 
    public class CustomerDataConext : DbContext
    {
        public CustomerDataConext(): base("DefaultConnectionString")
        {
            
        }
        public DbSet<Customer> Customers { get; set; }
    }
}
Here we need to add DbConfiguration Type attribute to tell Entity Framework that it is MySql EFConfiguration. So it will create a table based on MySql database.

Note: When you write connection string in app.config file then do not forgot to add providername =MySql.Data.MySqlClient. So connection string will look like following.
<connectionStrings>
    <add name="DefaultConnectionString" connectionString="your connectionstring" 
             providerName="MySql.Data.MySqlClient"/> 
</connectionStrings>
Following is a code for main console application.
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace EFWithMySQL
{
    class Program
    {
        static void Main(string[] args)
        {
            Customer customer = new Customer {FirstName = "Jalpesh", 
                                              LastName = "Vadgama",
                                              City = "Ahmedabad"};


            using (CustomerDataConext customerDataConext = new CustomerDataConext())
            {
                customerDataConext.Customers.Add(customer);
                customerDataConext.SaveChanges();
                Console.WriteLine("Customer Added Sucesscully");

                //Code to fetch data from MySQL
                foreach (var anotherCustomer in customerDataConext.Customers)
                {
                    Console.WriteLine("Customer Details");
                    Console.WriteLine(anotherCustomer.FirstName);
                    Console.WriteLine(anotherCustomer.LastName);
                    Console.WriteLine(anotherCustomer.City);
                }
            }

        }
    }
}
Here I have created a customer  object and saved it to database and then I have written code to fetch customer from database and display it on console application. 

Now It’s time to run application and following is output as expected.

output-as-expected

That’s it. Hope you like it. Stay tuned for more!!
You can find complete source code for this application on github at - https://github.com/dotnetjalps/EFWithMySql

Comments

Post a Comment

Your feedback is very important to me. Please provide your feedback via putting comments.

Popular posts from this blog

How to create Rest API(Web API) with ASP.NET Core 1.0

Recently Microsoft has released ASP.NET Core 1.0 RC2, I am getting lots of request from readers that about creating Web API. So I thought it will be a good idea to write a blog post about how to create Rest API(Web API) with ASP.NET Core 1.0.

So let’s get started via creating an ASP.NET Core 1.0 Web Application like following.



Once you click on ASP.NET Web Application, It will ask whether you need to create Web Application or Web API application. We are going to Web API so I am going to select Web API Application like following. Please note that in ASP.NET Core 1.0 there is no separate libraries or DLLs required for creating web APIs. This is just a project template.



Now once you click on OK It will create a Web API application with default values controller and program.cs.  As you know Program.cs is now starting point for the ASP.NET Core 1.0 application so It contains all the required configuration and startup items. Following is a code for that.
using System.IO; using Microsoft.Asp…

How to use migration with Entity Framework Core

Entity framework core is  the lightweight, extensible and cross-platform version of Entity Framework. Before some time, Microsoft has Released a new version of Entity Framework RC2. I have written a couple of blog post about Entity framework code first migration earlier for Entity framework 6.0. So there was a couple of request coming for writing a blog post about Entity Framework Core RC2 migration. So I thought it will be a good idea to give an overview how database migration works in Entity Framework Core RC2. This post will cover a basic scenario where we are going to create the database with existing ASP.NET Identity migration and then we are going to create a new model and have that migration applied in the database.

How to use Entity Framework Migrations: Let’s get started, To demonstrate entity framework core migrations, I am going to create a sample asp.net core web application like following.



Once we select asp.net core application it will appear the following dialog.



Now w…

Solution: gulp is not recognized as internal or external command- Visual Studio

Recently, After Upgrading to the newer version of Gulp, I was getting this error.  After doing lots of  finding online and in my system I was able to figure out that Modules like Gulp does not installed to the path. So when you try to run it from the command line it was showing below error.
gulp is not recognized as internal or external command How to solve : gulp is not recognized as internal or external command To solve this error we just need to create a new environment variable and set the NPM modules path there.

To create an environment variable,  Right click My Computer/ This Pc and click on properties.  It will open following windows.



Go to Advance System Settings and it will open system properties windows like below.



Click on Environment Variables it will open an environment and system variables windows like below.



Click on new System variable and put NODE_PATH in system variable name and %AppData%\npm\node_modules into the variable value like below.



Click on Ok. That’s it. N…