如何使用实体框架处理表单数据并提取两个不同模型/表的属性

// 定义模型类
public class Model1
{
    public int Id { get; set; }
    public string Property1 { get; set; }
}

public class Model2
{
    public int Id { get; set; }
    public string Property2 { get; set; }
}

// 创建数据库上下文
public class MyDbContext : DbContext
{
    public DbSet<Model1> Models1 { get; set; }
    public DbSet<Model2> Models2 { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("连接字符串");
    }
}

// 处理表单数据
public class MyService
{
    private readonly MyDbContext _dbContext;

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

    public void ProcessFormData(FormData formData)
    {
        var model1 = new Model1
        {
            Property1 = formData.Property1
        };

        var model2 = new Model2
        {
            Property2 = formData.Property2
        };

        _dbContext.Models1.Add(model1);
        _dbContext.Models2.Add(model2);
        _dbContext.SaveChanges();
    }

    public List<string> GetProperties()
    {
        var properties1 = _dbContext.Models1.Select(m => m.Property1).ToList();
        var properties2 = _dbContext.Models2.Select(m => m.Property2).ToList();

        return properties1.Concat(properties2).ToList();
    }
}

// 使用示例
public class HomeController : Controller
{
    private readonly MyService _myService;

    public HomeController(MyService myService)
    {
        _myService = myService;
    }

    [HttpPost]
    public IActionResult ProcessForm(FormData formData)
    {
        _myService.ProcessFormData(formData);
        return RedirectToAction("Index");
    }

    public IActionResult Index()
    {
        var properties = _myService.GetProperties();
        return View(properties);
    }
}