插入到EFCoreASP.NETCoreRazorPages.NET6中自動生成的Bridge表

我是 EF 的新手，需要幫助來理解以下內容：我在資料庫中有一個 Class 表和一個 Students 表。一個班級可以有很多學生，一個學生可以在很多班級。我有一個由 EF 核心自動生成的表，稱為 ClassModelStudent。它有以下欄位：

我創建了一個 razor 頁面來創建類，在發布事件時，按鈕應該發送 ClassID 并重定向到 AddStudents 頁面。

以下是 AddStudents 類的代碼：

using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
using Microsoft.AspNetCore.Mvc.Rendering;
using Microsoft.Data.SqlClient;
using Microsoft.EntityFrameworkCore;
using TestProject.Model;

namespace TestProject.Pages.Classes
{
    public class EnrollmentModel : PageModel
    {
        private readonly TestProject.Data.TestProjectContext _context;

    public EnrollmentModel(TestProject.Data.TestProjectContext context)
    {
        _context = context;
    }
    [BindProperty]
   public Enrollment Enrollments { get; set; }   
    public SelectList Classes { get; set; }    
    public IList<Student> UserProfile { get; set; }
    [BindProperty(SupportsGet = true)]
    public string? SearchString { get; set; }
    public async Task OnGetAsync()
    {
        var students = from s in _context.User_Profile
                       select s;
        if (!string.IsNullOrEmpty(SearchString))
        {
            students = students.Where(s => s.FirstName.Contains(SearchString));
        }

        UserProfile = await students.ToListAsync();

        var classes = from i in _context.Class
                          orderby i.Description
                          select i;

        Classes = new SelectList(classes, "ClassID", 
"Description");

    }

    public async Task<IActionResult> OnPostAsync()
    {
        if (!ModelState.IsValid)
        {

            return Page();
        }
       //THIS IS WHERE I TRIED ACCESSING CLASSMODELSTUDENT TABLE 
      //AND THE CONTEXT DID NOT SEE IT
       // _context.e
        await _context.SaveChangesAsync();

        return RedirectToPage("./Index");
    }
}

}

我目前已將其連接到 Enrollments 表。我什至不確定它是否應該將其寫入自動生成的表 ClassModelStudents 或手動創建的 Enrollments？注冊表如下所示：

In AddStudents page, I am showing the list of students in a table. I have created 'Add To Class' button in each row of the table. And I want to add that student to the selected class when 'add to class' button is clicked. I should be writing to ClassModelStudents table. Please see below the screenshot of AddStudents Page:

The thing I am not understanding is how to create the class (Model) for ClassModelStudent? As I cannot access this table directly using context. How to access this table to write the ClassID and StudentID to it?

Please advise.. I would really appreciate your assistance..

following is my model class for ClassModel:

 public class ClassModel

{
    [Key]
    [Required]
    [Display(Name ="Class ID")]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int ClassID { get; set; }
    //[ForeignKey("UserProfile")]
    //[Display(Name = "User ID")]
    //public virtual int ID { get; set; }
    [Required]
    public string Description { get; set; } 
    [Required]
    public int Occurence { get; set; }
    [Required]
    [DataType(DataType.Date)]
    public DateTime Startdate { get; set; }
    [Required]
    [DataType(DataType.Time)]
    public DateTime From { get; set; }
    [Required]
    [DataType(DataType.Time)]
    //[GreaterThanOrEqualTo("From")]
    public DateTime To { get; set; }
    [Required]
    [DataType(DataType.Currency)]
    public double Fees { get; set; }

    [DisplayFormat(NullDisplayText = "No Instructor Assigned")]
    [ForeignKey("InstructorID")]
    public virtual int InstructorID { get; set; }
    public Instructor? Instructor { get; set; }

    [DisplayFormat(NullDisplayText = "No Student Assigned")]
    public ICollection<Student>? Students { get; set; }

    public ICollection<Enrollment>? Enrollment  { get; set; }
}

THIS Is Enrollments class model:

public class Enrollment
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int EnrollmentID { get; set; }
    [Required]

    [ForeignKey("ClassID")]
    public virtual int ClassID { get; set; }
    [Required]
    [ForeignKey("StudentID")]
    public virtual int StudentID { get; set; }
    [Required]
    public ClassModel? Class { get; set; }
    [Required]
    public Student? Student { get; set; }

    

}

Below is Student Model:

public class Student
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    [Display(Name = "StudentID")]
    public int StudentID { get; set; }
    [Required]
      
    public string FirstName { get; set; }

    [Required]

    public string LastName { get; set; }
   
    
    [Required]
    public Boolean Status { get; set; }
    [DataType(DataType.Date)]
    public DateTime DateOfBirth { get; set; }
    [Required]
    [DataType(DataType.EmailAddress)]
    public string Email { get; set; }
    [Required]
    [Phone]
    [DataType(DataType.PhoneNumber)]
    public string PhoneNumber { get; set; }

    public string EmergencyContactName { get; set; }
    [Phone]
    [DataType(DataType.PhoneNumber)]
    public string EmergencyContactNumber { get; set; }

    [Required]
    public string Gender { get; set; }

    public string FullName
    {
        get { return LastName   ", "   FirstName; }
    }
    [DisplayFormat(NullDisplayText = "No Class Assigned")]
    public ICollection<ClassModel>? Classes { get; set; }

    public ICollection<Enrollment>? Enrollments { get; set; }    
}

I do not have the code for ClassModelStudent as it is autogenerated.

uj5u.com熱心網友回復：

當您在 中創建many-to-many關系時TestProjectContext，您是否像這樣撰寫代碼：

    .......

    public Dbset<Class> classes;
    public Dbset<students> students;

該ClassModelStudent表由EF核心自動生成的，所以你不能使用_context.ClassModelStudent插入任何資料？

如果你的問題像我上面提到的，你可以使用另一種方法來創建many-to-many關系，我寫了一個簡單的演示：

模型

 public class Group
    {
        public int Id { get; set; }
        public string GroupName { get; set; }
        public List<GroupMembers> GroupMembers { get; set; }
    }

public class User
    {
        public int Id { get; set; }
        public string UserName { get; set; }
        public List<GroupMembers> GroupMembers { get; set; }
    }

public class GroupMembers
    {
        public int Id { get; set; }
        public int UserId { get; set; }
        public User user { get; set; }

        public int GroupId { get; set; }
        public Group group { get; set; }
    }

資料背景關系

public class WebTestContext : DbContext
    {
        public WebTestContext(DbContextOptions<WebTestContext> options):base(options)
        {

        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<GroupMembers>()
                .HasKey(gm => new { gm.UserId, gm.GroupId });
            modelBuilder.Entity<GroupMembers>()
                .HasOne(gm => gm.group)
                .WithMany(group=> group.GroupMembers)
                .HasForeignKey(gm => gm.GroupId);
            modelBuilder.Entity<GroupMembers>()
                .HasOne(gm => gm.user)
                .WithMany(user => user.GroupMembers)
                .HasForeignKey(gm => gm.UserId);
        }
        public DbSet<User> usertable { get; set; }
        public DbSet<Group> grouptable { get; set; }
        public DbSet<GroupMembers> GroupMembers { get; set; }
    }

這種方式在 DataContext 中創建多對多關系，可以_context.(Relational tables)在 pagemodel 中使用。

================================================== ==========

如果Enrollmenttable 是ClassModeland的關系表，則Student不需要讓 EF 核心創建其他關系表。

模型

public class ClassModel
    {
        [Key]
        public int ClassID { get; set; }
        public string Description { get; set; }
        public string ClassName { get; set; }
        
        public ICollection<Enrollment>? Enrollments { get; set; }
    }

public class Enrollment
    {
        [Key]
        public int EnrollmentID { get; set; }
        

        [ForeignKey("ClassID")]
        public virtual int ClassID { get; set; }
        [Required]
        [ForeignKey("StudentID")]
        public virtual int StudentID { get; set; }
        [Required]
        public ClassModel? Class { get; set; }
        [Required]
        public Student? Student { get; set; }
    }

public class Student
    {
        [Key]
        public int StudentID { get; set; }
        public string FirstName { get; set; }
        public string Email { get; set; }

        public ICollection<Enrollment>? Enrollments { get; set; }
    }

測驗專案背景關系

public class TestProjectContext : DbContext
    {
        public TestProjectContext(DbContextOptions<TestProjectContext> options) : base(options)
        {

        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Enrollment>()
                .HasKey(gm => new { gm.ClassID, gm.StudentID });
            modelBuilder.Entity<Enrollment>()
                .HasOne(gm => gm.Class)
                .WithMany(group => group.Enrollments)
                .HasForeignKey(gm => gm.ClassID);
            modelBuilder.Entity<Enrollment>()
                .HasOne(gm => gm.Student)
                .WithMany(user => user.Enrollments)
                .HasForeignKey(gm => gm.StudentID);
        }

        public DbSet<ClassModel> ClassModels { get; set; }
        public DbSet<Student> students { get; set; }
        public DbSet<Enrollment> enrollments { get; set; }
    }

那么，你只有三張桌子

您可以在 PageModel 中使用它們中的任何一個

標籤：c# asp.net asp.net-core entity-framework-core razor-pages

上一篇：在ASP.NETMVC應用程式中設定會話持續時間在web.config中不起作用

下一篇：C中的遞回生物項系數