//繼承自DbContext類，
　　//數(shù)據(jù)上下文類，用于操作數(shù)據(jù)庫。負責維護實體狀態(tài)，以及根據(jù)實體對象包裝類的狀態(tài)屬性，生成不同的SQL語句執(zhí)行
  public partial class OumindBlogEntities : DbContext
  {
    public OumindBlogEntities()
      : base("name=OumindBlogEntities")
    {
    }
  
    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
      throw new UnintentionalCodeFirstException();
    }
  
    public DbSet<BlogArticle> BlogArticles { get; set; }
    public DbSet<BlogArticleCate> BlogArticleCates { get; set; }
    public DbSet<BlogUser> BlogUsers { get; set; }
    public DbSet<Enumeration> Enumerations { get; set; }
  }

 //EF按照實體模型生成的實體類
  public partial class BlogArticleCate
  {
    public BlogArticleCate()
    {
      this.BlogArticles = new HashSet<BlogArticle>();
    }
  
    public int Id { get; set; }
    public int Author { get; set; }
    public string Name { get; set; }
    public string Remark { get; set; }
    public int Statu { get; set; }
    public bool IsDel { get; set; }
    public System.DateTime Addtime { get; set; }
  
    //生成的外鍵屬性
    public virtual ICollection<BlogArticle> BlogArticles { get; set; }
    public virtual BlogUser BlogUser { get; set; }
  }

//創(chuàng)建數(shù)據(jù)庫上下文類的對象
    OumindBlogEntities db = new OumindBlogEntities();

    #region 查詢文章列表+ActionResult Article()
    /// <summary>
    /// 查詢文章列表
    /// </summary>
    /// <returns></returns>
    public ActionResult Article()
    {
      //通過db對象獲取文章列表
      db.BlogArticles.Where(p => p.AIsDel == false);//使用Lamabda表達式來獲取為被刪除的文章
      
      //使用Lamabda表達式來獲取數(shù)據(jù)
      //返回一個List<T>的對象來存儲文章列表
      List < Models.BlogArticle > list= db.BlogArticles.Where(p => p.AIsDel == false).ToList();
      
      
      //也可以使用Linq來獲取數(shù)據(jù) 
      List<Models.BlogArticle> list1 = (from p in db.BlogArticles where p.AIsDel == false select p).ToList();

      //使用ViewData來傳遞list對象
      ViewData["DataList"] = list;

      return View();
    } 
    #endregion

<!------------首先導入命名空間------------->>
@using MvcApplication1.Models;
 然后顯示數(shù)據(jù)的代碼是：

復制代碼
 <!------------獲取數(shù)據(jù)并顯示html------------->>
  <div>
    <table id="tbList">
      <tr>
        <th>id</th>
        <th>標題</th>
        <th>分類</th>
        <th>狀態(tài)</th>
        <th>時間</th>
        <th>操作</th>
      </tr>
      <!--遍歷 Action方法 設(shè)置給 ViewData 的集合數(shù)據(jù)，生成HTML代碼-->
      @foreach (BlogArticle a in ViewData["DataList"] as List<BlogArticle>)
      {
        <tr>
          <td>@a.AId</td>
          <td>@a.ATitle</td>
          <td>@a.BlogArticleCate.Name</td>
          <td>@a.Enumeration.e_cname</td>
          <td>@a.AAddtime</td>
          
        </tr>
      }
    </table>
  </div>