我希望Technology将显示在Create中的下拉列表中

Question

我希望我的技术文本框将显示在下拉列表中，但是类是不同的，项目是一个类，技术是另一个类

public class Project
    {
        public int ProjectId { get; set; }

        [StringLength(60, MinimumLength = 3)]
        [Required]
        public string? ProjectName { get; set; }

        [Required]
        public string? Description { get; set; }

        [Required]
        public DateTime Start { get; set; }

        public DateTime? End { get; set; }

        [Required]
        public string? ProjectHead { get; set; }

        [Required]
        public string? Status { get; set; }

        public string? Technology { get; set; }

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

public class Technology
    {
        public int TechnologyId { get; set; }
        public string? TechnologyName { get; set; }

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

public class ProjectTechnology
    {
        public int Id { get; set; }
        public int ProjectId { get; set; }
        public int TechnologyId { get; set; }

        public Project? Project { get; set; }
        public Technology? Technology { get; set; }
    }

这是我的Css html页面，它将创建使用脚手架，我希望这将显示在下拉获取数据从数据库在技术领域。

<div class="row">
        <div class="form-group col-md-6">
            <label asp-for="Technology" class="control-label"></label>
            <input asp-for="Technology" class="form-control" />
            <span asp-validation-for="Technology" class="text-danger"></span>
        </div>
    </div>

Answer 1

试一试

Project.cs：

public class Project
        {
            public int ProjectId { get; set; }
    
            [StringLength(60, MinimumLength = 3)]
            [Required]
            public string? ProjectName { get; set; }
    
            [Required]
            public string? Description { get; set; }
    
            [Required]
            public DateTime Start { get; set; }
    
            public DateTime? End { get; set; }
    
            [Required]
            public string? ProjectHead { get; set; }
    
            [Required]
            public string? Status { get; set; }
    
            
           public int TechnologyId { get; set; }
           public Technology Technology{ get; set; } 

            
    }

Technology.cs

public class Technology
    {
        public int TechnologyId { get; set; }
        public string? TechnologyName { get; set; }

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

在Program.cs中，添加如下代码：

builder.Services.AddDbContext<MyDbContext>(options =>
    options.UseSqlite(builder.Configuration.GetConnectionString("MyDbContext")));

在appsettings.json中：

"ConnectionStrings": {
    "MyDbContext": "Filename= C:\\Users\\Administrator\\sqlite\\ITProjectDB.db"
  }

MyDbContext：

public class MyDbContext : DbContext
    {
        public MyDbContext(DbContextOptions<MyDbContext> options) : base(options) { }
        public DbSet<Technology> Technology { get; set; }
        public DbSet<Project> Project { get; set; }

       
    }

结果：

​

​