将表数据映射到asp .Net MVC中的ViewModel列表

public class MyViewModel
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int Age { get; set; }
}

public class MyDAL
{
    public List<MyViewModel> GetViewModelList()
    {
        List<MyViewModel> viewModelList = new List<MyViewModel>();

        // 连接数据库，执行查询操作并获取数据
        // 假设从表"Users"中检索数据
        string query = "SELECT * FROM Users";
        DataTable dataTable = ExecuteQuery(query); // 执行查询并获取结果集

        // 将每一行数据映射到ViewModel对象并添加到列表中
        foreach (DataRow row in dataTable.Rows)
        {
            MyViewModel viewModel = new MyViewModel();
            viewModel.Id = Convert.ToInt32(row["Id"]);
            viewModel.Name = row["Name"].ToString();
            viewModel.Age = Convert.ToInt32(row["Age"]);

            viewModelList.Add(viewModel);
        }

        return viewModelList;
    }
}

public class MyController : Controller
{
    public ActionResult Index()
    {
        MyDAL myDAL = new MyDAL();
        List<MyViewModel> viewModelList = myDAL.GetViewModelList();

        return View(viewModelList); // 将ViewModel列表传递给视图
    }
}

@model List<MyViewModel>

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