如何使用Asp.net core MVC从不同的表中查看数据，并将数据从一个视图页面插入到另一个表中？

// 实体模型
public class Table1
{
    public int Id { get; set; }
    public string Name { get; set; }
}

public class Table2
{
    public int Id { get; set; }
    public string Description { get; set; }
}

// 数据访问层
public class MyDbContext : DbContext
{
    public DbSet<Table1> Table1 { get; set; }
    public DbSet<Table2> Table2 { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("YourConnectionString");
    }
}

public class MyRepository
{
    private readonly MyDbContext _dbContext;

    public MyRepository(MyDbContext dbContext)
    {
        _dbContext = dbContext;
    }

    public List<Table1> GetTable1Data()
    {
        return _dbContext.Table1.ToList();
    }

    public void InsertTable2Data(Table2 data)
    {
        _dbContext.Table2.Add(data);
        _dbContext.SaveChanges();
    }
}

// 控制器
public class HomeController : Controller
{
    private readonly MyRepository _repository;

    public HomeController(MyRepository repository)
    {
        _repository = repository;
    }

    public IActionResult Index()
    {
        var table1Data = _repository.GetTable1Data();
        return View(table1Data);
    }

    [HttpPost]
    public IActionResult InsertData(Table2 data)
    {
        _repository.InsertTable2Data(data);
        return RedirectToAction("Index");
    }
}

// 视图
@model List<Table1>

@foreach (var item in Model)
{
    <p>@item.Name</p>
}

<form asp-action="InsertData" method="post">
    <input type="text" name="Description" />
    <button type="submit">Insert</button>
</form>