Getting started with ASP.NET CORE-CSDN博客

2019独角兽企业重金招聘Python工程师标准>>>

Create a new project in

File > New > Project
From the left menu select Installed > Templates > Visual C# > .NET Core.
Select ASP.NET Core Web Application.
Enter EFGetStarted.AspNetCore.NewDb for the name and click OK.
In the New ASP.NET Core Web Application dialog:
- Ensure the options .NET Core and ASP.NET Core 2.0 are selected in the drop down lists
- Select the Web Application (Model-View-Controller) project template
- Ensure that Authentication is set to No Authentication
- Click OK

1)Install Nug_packages

Mysql.Data.EntityFrameworkCore

Microsoft.EntityFrameworkCore.Tools

Microsoft.VisualStudio.Web.CodeGeneration.Design

2)Create your model

using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace WebApplication1.Models
{
    public class BloggingContext : DbContext
    {
        public BloggingContext(DbContextOptions<BloggingContext> options)
            : base(options)
        { }

        public DbSet<Blog> Blogs { get; set; }
        public DbSet<Post> Posts { get; set; }
    }

    public class Blog
    {
        public int BlogId { get; set; }
        public string Url { get; set; }

        public List<Post> Posts { get; set; }
    }

    public class Post
    {
        public int PostId { get; set; }
        public string Title { get; set; }
        public string Content { get; set; }

        public int BlogId { get; set; }
        public Blog Blog { get; set; }
    }
}

3)Edit your appsettings.json

{
  "Logging": {
    "IncludeScopes": false,
    "LogLevel": {
      "Default": "Debug",
      "System": "Information",
      "Micorsoft": "Information"
    }
  },
  "ConnectionStrings": {
    "MySql": "server=localhost;port=3306;database=test;uid=root;password=123;"
  }
}

4)Edit your "Startup.cs" ,register your MySql service in "ConfigureServices"

        public void ConfigureServices(IServiceCollection services)
        {
            services.AddDbContext<BloggingContext>(options => options.UseMySQL(Configuration.GetConnectionString("MySql")));
            services.AddMvc();
        }

5)Generate your "***(project name).csproj" by right click your mouse on the project

Create your database

1)run "Add-Migration InitialCreate" in your Package Manager Console ,to scaffold a migration to create the initial set of tables for your model. If you receive an error stating

2)Update-Database

Create a database

Right-click on the Controllers folder in Solution Explorer and select Add > Controller.
Select MVC Controller with views, using Entity Framework and click Ok.
Set Model class to Blog and Data context class to BloggingContext.
Click Add.