Asp.net Core 2.1使用 EF Core 简单增删改查操作数据库

待我称王封你为后i 2021-11-26 08:16 363阅读 0赞

**Asp.net Core 2.1使用 EF Core 简单增删改查操作数据库 大概步骤如下5步：**

1、创建项目（Asp.net Core 2.1项目）

2、项目使用EF Core

3、建立实体

4、生成迁移文件（生成数据库）

5、使用VS工具生成视图、控制器代码

[ 示例代码下载][Link 1]  https://github.com/ZhMartincheng/NetCoreDemo.git

**1、创建项目（Asp.net Core 2.1项目）**

![600410-20181022222235282-1204446067.png][]

选择.net core 版本2.1

![600410-20181022222338407-304899132.png][]

基础项目创建成功![600410-20181022222459352-1346436711.png][]

**2、项目使用EF Core**

2.1、通过nuget 安装Microsoft.EntityFrameworkCore.SqlServer

项目右键管理nuget包

![600410-20181022222832427-613293790.png][]

![600410-20181022222944224-1286694875.png][]

安装成功

![600410-20181022223520157-326238914.png][]

**3、建立实体**

**学生实体**

public class Student
        {
    
          public int ID { get; set; }
    
            public string Name { get; set; }
    
            public int Age { get; set; }
    
          public int ClassEnityId { get; set; }
    
         public ClassEntiy classEnity { get; set; }
    
        }

**班级实体（一个班级多个学生）**

public class ClassEntiy
        {
    
            public int ID { get; set; }
    
            public string ClassName { get; set; }
    
    
            public virtual ICollection<Student> Students { get; set; }
    
        }

![600410-20181022224500568-140743518.png][]

** **

**4、生成迁移文件（生成数据库）**

配置链接字符串 "ConnectionStrings": \{"SqlServer": "Data Source=.;Initial Catalog=TestDb;User Id=sa;Password=123;"\}

![600410-20181022223710185-508752470.png][]

创建 上下文对象 DbContext

using Microsoft.EntityFrameworkCore;
    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Threading.Tasks;
    
    namespace NetCoreDemo.Models
    {
        public class ApplicationDbContext : DbContext
        {
            public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options)
            {
    
            }
            public DbSet<Student> Student { get; set; }
            public DbSet<ClassEntiy> ClassEntitys { get; set; }
        }
    }

![600410-20181022225120287-1625822320.png][]

代码配置数据库链接串

var connection = Configuration.GetConnectionString("SqlServer");
    services.AddDbContext<NetCoreDemo.Models.ApplicationDbContext>(options =>
    options.UseSqlServer(connection, b => b.MigrationsAssembly("NetCoreDemo")));

![600410-20181022225800548-875038636.png][]

编译成功后执行生成迁移文件命令add-Migration Init

![600410-20181022230241122-707386006.png][]

通过迁移文件生成数据库Update-Database

![600410-20181022230731065-883559832.png][]

![600410-20181022230754831-1520948151.png][]

数据库生成成功。

**5、使用VS工具生成视图、控制器代码**

创建学生控制器

**![600410-20181022230900886-457957980.png][]**

现在数据库上下文和实体

![600410-20181022230959028-749521120.png][]

创建班级控制器

![600410-20181022231341734-2123582381.png][]

**测试一下效果**

首页链接修改一下

![600410-20181023092102675-1875221532.png][]

![600410-20181023092124520-152353126.png][]

新增班级

![600410-20181023092308044-849063019.png][]

班级列表

![600410-20181023092408410-1583809253.png][]

增加学生信息

![600410-20181023102643076-2095856521.png][]

![600410-20181023102721971-1201480909.png][]

班级显示编码没显示名称，修改生成代码（create 和edit方法）

![600410-20181023103507187-1559406017.png][]

![600410-20181023103616064-665367394.png][]

终于完成看效果

![600410-20181023103715817-1278448146.png][]

编辑效果

![600410-20181023103750914-289792548.png][]

转载于:https://www.cnblogs.com/Martincheng/p/9833413.html

[Link 1]: https://github.com/ZhMartincheng/NetCoreDemo.git
[600410-20181022222235282-1204446067.png]: /images/20211126/33ee70941f1747c39b2702a6492225c8.png
[600410-20181022222338407-304899132.png]: /images/20211126/d5f1ed5df1f9457ea0e640465b84b92d.png
[600410-20181022222459352-1346436711.png]: /images/20211126/97e0537296354bf997c2cc7c3aec7674.png
[600410-20181022222832427-613293790.png]: /images/20211126/cdc3733b7b36402a800aafeb7a2b22fe.png
[600410-20181022222944224-1286694875.png]: /images/20211126/16d3f67e3d724f39bf2889458b55c36c.png
[600410-20181022223520157-326238914.png]: /images/20211126/2de55cefe13542fdb0768a3ecb655d1b.png
[600410-20181022224500568-140743518.png]: /images/20211126/b73cfa71bb58429aa0b9906ac0ce2723.png
[600410-20181022223710185-508752470.png]: /images/20211126/73076adc7c534c0894e6a5b3bbf63dcd.png
[600410-20181022225120287-1625822320.png]: /images/20211126/abca166cd7f540f393c3f47c6f8dd43d.png
[600410-20181022225800548-875038636.png]: /images/20211126/6bd6428008894e1a9c0f7340f1e3a155.png
[600410-20181022230241122-707386006.png]: /images/20211126/1751791a9d4b4a99b58dd64dd4cc1fa8.png
[600410-20181022230731065-883559832.png]: /images/20211126/5a4f2bad38e84324be429ba82324ea08.png
[600410-20181022230754831-1520948151.png]: /images/20211126/5777ab9238ba4ddfb9181061a5860884.png
[600410-20181022230900886-457957980.png]: /images/20211126/fd0a61a962b14866a93c92e78259b5c9.png
[600410-20181022230959028-749521120.png]: /images/20211126/c3f41f60f2474ec9bcbed054e7aac29a.png
[600410-20181022231341734-2123582381.png]: /images/20211126/c06272a7026e4a59858386d13d8e5550.png
[600410-20181023092102675-1875221532.png]: /images/20211126/d339c4c3c9134ee09addd4e13968fcf4.png
[600410-20181023092124520-152353126.png]: /images/20211126/42b4928577aa4e4db8bc993bbe0574b9.png
[600410-20181023092308044-849063019.png]: /images/20211126/b1d87398c53943e299e666b517dea465.png
[600410-20181023092408410-1583809253.png]: /images/20211126/22d54e23572e4754929720b0e66645cd.png
[600410-20181023102643076-2095856521.png]: /images/20211126/8650f0a930b44641898426b15ef74936.png
[600410-20181023102721971-1201480909.png]: /images/20211126/5bf61ad29d0545e699462f156a48f646.png
[600410-20181023103507187-1559406017.png]: /images/20211126/d8bb4eae1ff04aaba737675af5ea3ef4.png
[600410-20181023103616064-665367394.png]: /images/20211126/9fb8081f0036488697a1e2c2a9a2ea6a.png
[600410-20181023103715817-1278448146.png]: /images/20211126/b257b8b242044c639607db765ee70cd6.png
[600410-20181023103750914-289792548.png]: /images/20211126/6510e3e441b544d6bd2834087c993623.png