显示项目列表。在我的案例中，用户列表

Question

我一直在尝试列出我的数据库中的所有用户，但我遇到了困难。我是MVC3新手，请帮助我。:)

这是我的UserList

using System;
using System.Data.Entity;
using System.Collections.Generic;
 using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;
using MVCDemo.Models.DB;
using MVCDemo.Models.ViewModel;

namespace MVCDemo.Models.ViewModel
{


    public class UserList
    {

        public string FirstName { get; set; }
        public string LastName { get; set; }
        public string ContactNumber { get; set; }
        public string Address { get; set; }
        public string Email { get; set; }
        public string Username { get; set; }
        public string Password { get; set; }

     }

    public class Users
    {
        private DeveloperReportEntities dre = new DeveloperReportEntities();
        public UserList _userList = new UserList();


        public Users()
        {
            DB.Users_Tbl userTBL = new DB.Users_Tbl();
            _userList.FirstName = userTBL.FirstName;
            _userList.LastName = userTBL.LastName;
            _userList.Email = userTBL.Email;
            _userList.Address = userTBL.Address;
            _userList.ContactNumber = userTBL.ContactNo;
            _userList.Username = userTBL.Username;
            _userList.Password = userTBL.Password;
         }


    }
}

应该是通过这里控制的: AdminController

    public class AdminController : Controller
    {
        //
         // GET: /Admin/

        public ActionResult AdminHomePage()
        {
             return View();
        }

        public ActionResult ViewAll()
         {
            return View();
         }
     }   

在我的解决方案资源管理器中，模型文件夹中有一个samplemodel.edmx

Answer 1

首先，Users类应该封装User的List。下面是它应该是什么样子：

/Controllers/Admin/AdminController.cs

public class User
{
   public string FirstName { get; set; }
   public string LastName { get; set }
}

public class AdminController : Controller
{
    //
    // GET: /Admin/
    public ActionResult AdminHomePage()
    {
         return View();
    }

    public ActionResult ViewAll()
    {
        var userTBL = new DB.Users_Tbl();
        var users = userTBL.Select(u => new User { FirstName = u.FirstName, LastName = u.LastName };
        return View(users);
    }
 }

/Views/Admin/ViewAll.cshtml

@model List<User>
<ul>
@foreach(var user in Model)
{
   <li>@user.FirstName @user.LastName</li>
}
</ul>