EF Core中创建一对一 ，一对多，多对多的数据关系

原文连接 讲解的已经很清楚了。(24条消息) 谈谈如何在EF Core中创建一对一 ，一对多，多对多的数据关系_David Hongyu的博客-CSDN博客

 自己 补充作者可能用到的 nuget包

Microsoft.EntityFrameworkCore.SqlServer

Microsoft.EntityFrameworkCore.Tools

从EF-Core5.0 支持多对多，补充 转载的 多对多 数据关系

最能 体现 多对多的 是 学生和老师。多个学生 对于多个老师

1.1 建立文件 Student.cs

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

namespace EF_Core06
{
    internal class Student
    {
        public long Id { get; set; }
        public string Name { get; set; }
        public List<Teacher> Teachers { get; set; }=new List<Teacher>();
    }
}

 1.2  建立文件 StudentConfig.cs

using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace EF_Core06
{
    internal class StudentConfig : IEntityTypeConfiguration<Student>
    {
        public void Configure(EntityTypeBuilder<Student> builder)
        {
            builder.ToTable("T_Students");
//.UsingEntity(t => t.ToTable("T_Student_Teacher")) 是EF-Core 自动为我们
//建立的中间表。
            builder.HasMany<Teacher>(o => o.Teachers).WithMany(o => o.Students).UsingEntity(t => t.ToTable("T_Student_Teacher"));
        }
    }
}

2.1 建立文件 Teacher.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace EF_Core06
{
    internal class Teacher
    {
        public long Id { get; set; }
        public string Name { get; set; }
        public List<Student> Students { get; set; } =new List<Student>();
    }
}

2.2 建立文件 TeacherConfig.cs

using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace EF_Core06
{
    internal class TeacherConfig : IEntityTypeConfiguration<Teacher>
    {
        public void Configure(EntityTypeBuilder<Teacher> builder)
        {
            builder.ToTable("T_Teachers");
        }
    }
}

 3. 建立DBcontext.cs

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

namespace EF_Core06
{
    internal class DBcontext:DbContext
    {
        public DbSet<Student> Students { get; set; }
        public DbSet<Teacher> Teachers { get; set; }
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            base.OnConfiguring(optionsBuilder);
            optionsBuilder.UseSqlServer("Data Source=ADMIN\\MSSQLSERVER2012A;Initial Catalog=demo6;User ID=sa;Password=123456");
        }
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);
            modelBuilder.ApplyConfigurationsFromAssembly(this.GetType().Assembly);
        }
    }
}

4.测试代码

using Microsoft.EntityFrameworkCore;

namespace EF_Core06
{
    internal class Program
    {
        static void Main(string[] args)
        {
            using (DBcontext db = new DBcontext())
            {
                //添加数据
                Student s1 = new Student() { Name="张三"};
                Student s2 = new Student() { Name="李四"};
                Student s3 = new Student() { Name="王五"};

                Teacher t1 = new Teacher() { Name = "李老师" };
                Teacher t2 = new Teacher() { Name = "张老师" };
                Teacher t3 = new Teacher() { Name = "王老师" };

                s1.Teachers.Add(t1);
                s2.Teachers.Add(t2);
                s3.Teachers.Add(t3);

                //全部添加，避免出错
                db.Students.Add(s1);
                db.Students.Add(s2);
                db.Students.Add(s3);

                db.Teachers.Add(t1);
                db.Teachers.Add(t2);
                db.Teachers.Add(t3);
                db.SaveChanges();

                //查询
                /*
               var Teacher = db.Teachers.Include(e => e.Students);
                foreach (var t in Teacher)
                {
                    Console.WriteLine(t.Name);
                    foreach (var s in t.Students)
                    {
                        Console.WriteLine("\t"+s.Name);
                    }
                }
                */
            }
        }
    }
}