ASP.NET Mvc開發(fā)之查詢數(shù)據(jù)

　//繼承自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 DbSetBlogArticle> BlogArticles { get; set; }
    public DbSetBlogArticleCate> BlogArticleCates { get; set; }
    public DbSetBlogUser> BlogUsers { get; set; }
    public DbSetEnumeration> Enumerations { get; set; }
  }

 //EF按照實體模型生成的實體類
  public partial class BlogArticleCate
  {
    public BlogArticleCate()
    {
      this.BlogArticles = new HashSetBlogArticle>();
    }
  
    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 ICollectionBlogArticle> 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ù)
      //返回一個ListT>的對象來存儲文章列表
      List  Models.BlogArticle > list= db.BlogArticles.Where(p => p.AIsDel == false).ToList();
      
      
      //也可以使用Linq來獲取數(shù)據(jù) 
      ListModels.BlogArticle> list1 = (from p in db.BlogArticles where p.AIsDel == false select p).ToList();

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

      return View();
    } 
    #endregion

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

復(fù)制代碼
 !------------獲取數(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 ListBlogArticle>)
      {
        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>