.net core 入门一

官网教程：https://docs.microsoft.com/zh-cn/aspnet/core/getting-started/?view=aspnetcore-3.0&tabs=windows

1.新建项目.NET CORE API

2.连接mysql（使用EF）

3.部署到windows-IIS

一新建项目.NET CORE API

二连接mysql（使用EF）

1.nuget：MySql.Data.EntityFrameworkCore Microsoft.EntityFrameworkCore

using System;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace LibraryModel
{
    [Table("School")]
    public class SchoolModel
    {
        [Key]
        public int Id { get; set; }
        public string SchoolName { get; set; }
    }
}

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

namespace LibrarySystem.DB
{
    public class LibraryContext : DbContext
    {
        public LibraryContext(DbContextOptions<LibraryContext> options) : base(options) { }
        public DbSet<SchoolModel> School { get; set; }
    }
}

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Threading.Tasks;
using LibrarySystem.DB;
using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.HttpsPolicy;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Logging;
using Microsoft.Extensions.Options;

namespace LibrarySystem
{
    public class Startup
    {
        public Startup(IConfiguration configuration)
        {
            Configuration = configuration;
        }

        public IConfiguration Configuration { get; }

        // This method gets called by the runtime. Use this method to add services to the container.
        public void ConfigureServices(IServiceCollection services)
        {
            var conn = Configuration.GetSection("ConnectionString:Default").Value;
            services.AddDbContext<LibraryContext>(options => options.UseMySQL(conn));

            services.AddDbContext<TodoContext>(opt =>
                opt.UseInMemoryDatabase("TodoList"));
            services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_2);
        }

        // This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
        public void Configure(IApplicationBuilder app, IHostingEnvironment env)
        {
            if (env.IsDevelopment())
            {
                app.UseDeveloperExceptionPage();
            }
            else
            {
                // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
                app.UseHsts();
            }

            app.UseHttpsRedirection();
            app.UseMvc();
        }
    }
}

{
  "Logging": {
    "LogLevel": {
      "Default": "Warning"
    }
  },
  "ConnectionString": {
    "Default": "server=127.0.0.1;userid=root;password=xxxx;port=3306;database=world;allowuservariables=True;"
  },
  "AllowedHosts": "*"
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using LibraryModel;
using LibrarySystem.DB;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;

namespace LibrarySystem.Controllers
{
    [Route("api/[controller]")]
    [ApiController]
    public class SchoolController : ControllerBase
    {
        LibraryContext context;
        public SchoolController(LibraryContext _context)
        {
            context = _context;
        }

        [HttpGet]
        [Route("Query")]
        public dynamic Query(int id)
        {
            var data = context.School.FirstOrDefault();

            return data;
        }

        [HttpGet]
        [Route("dosome")]
        public dynamic Dosome()
        {
            return "1111111";
        }

        [HttpGet]
        public dynamic GetList()
        {
            var data = context.School.ToList();

            return data;
        }

    }
}