Scribd
Upload
151 views3 pages

Connect MySQL with EntityFramework MVC

The document provides instructions for setting up a .NET MVC web application to use Entity Framework Core with a MySQL database. It describes installing the necessary NuGet packages, adding a connection string to the web.config file, creating DbContext and model classes, enabling migrations, and adding an API controller to perform CRUD operations on the Product model.

Uploaded by

Chandrakant Patil
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
151 views3 pages

Connect MySQL with EntityFramework MVC

The document provides instructions for setting up a .NET MVC web application to use Entity Framework Core with a MySQL database. It describes installing the necessary NuGet packages, adding a connection string to the web.config file, creating DbContext and model classes, enabling migrations, and adding an API controller to perform CRUD operations on the Product model.

Uploaded by

Chandrakant Patil
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

if you want to work with MySql database using EntityFramework project that uses

[Link] (latest version is 6.10.X) and [Link] (latest version is 8.0.X). Those
version numbers should match. You should use the [Link] package
with [Link] version 8.0 and after, and the [Link] package with versions
6.10 and before.

Create a New Project Using Visual Studio =>

Web => [Link] Web Application => Select MVC Project Template

Authentication => No Authentication

Open NuGet Package Manager Console

Tools => NuGet Package Manager => Package Manager Console

1) Enter Command => Install [Link] => Press Enter ( You have to connected to
internet)

2) Enter Command => Install [Link] ( You have to connected to


internet)

After installing packages go to web config file and add connection string with name
DefaultConnection, be sure u have installed mysql server on your local computer or set
connection string for remote server.

<add name="DefaultConnection" connectionString="server=localhost;userid=root;password=root;data


base=testDb;persistsecurityinfo=true" providerName="[Link]" />

replace user name password as per your environment.

Add New Class In Models Folder

[DbConfigurationType(typeof(MySqlEFConfiguration))]
public class ApplicationDbContext : DbContext
{

public DbSet Products { get; set; }


public ApplicationDbContext()
:base("DefaultConnection") //Connection string name write here
{
}
}

Add New Class File In Models Folder

public class Product


{
public int Id { get; set; }

[Required]
[StringLength(50)]
public string Name { get; set; }
}

Go to Package Manager Console

Tools => NuGet Package Manager => Package Manager Console

Execute Following Commands step by step


1) Enable-migrations
2) add-migration InitialModel
3) update-database

Done We Successfully connected MySql Database with EntityFramework.

If you want to check open the mysql workbench and check there is a database created with
name testDb and it has products table also.

Add New API Controller and Add Following code to in.

Please add the following line to [Link] file

[Link]([Link]);

public class ProductsController : ApiController


{
private static ApplicationDbContext _context;
public ProductsController()
{
_context = new ApplicationDbContext();
}
protected override void Dispose(bool disposing)
{
_context.Dispose();
}
// GET /api/products
public IEnumerable<Product> GetProducts()
{
return _context.[Link]();
}
//GET /api/products/id
public Product GetProducts(int id)
{
return _context.[Link](p => [Link] == id);
}

Build your application and test your api going following url:
http:localhost:port/api/products (replace port no with your application port)

you can also test your api using postman or any other restclient
Thank you

You might also like