USE [yanComdb] 
GO 
/****** 对象: Table [dbo].[NewsEntity] 脚本日期: 03/12/2012 22:03:59 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[NewsEntity]( 
 [NId] [int] IDENTITY(1,1) NOT NULL, 
 [Title] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, 
 [Information] [text] COLLATE Chinese_PRC_CI_AS NULL, 
 [Time] [datetime] NOT NULL CONSTRAINT [DF_NewsEntity_Time] DEFAULT (getdate()), 
 CONSTRAINT [PK_NewsEntity] PRIMARY KEY CLUSTERED 
( 
 [NId] ASC 
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] 

[TableAttribute("NewsEntity")]//这行很重要，因为mvc框架默认去db中找类名复数的表名 
 public class NewsEntity 
 { 
  [Key]//设置主键 
  public int NId { get; set; } 
 
  [StringLength(100)]//设置验证信息 
  [Required(ErrorMessage="标题不能为空")] 
  [DisplayName("标题")] 
  public string Title { get; set; } 
 
  [Required(ErrorMessage = "正文必须填写")] 
  [DisplayName("正文")] 
  public string Information { get; set; } 
 
  public DateTime Time { get; set; } 
 } 

<connectionStrings> 
<add name="ProjectEntity" connectionString="Data Source=ip;Initial Catalog=yanComdb;Persist Security Info=True;User ID=;Password=" 
providerName="System.Data.SqlClient" /> 
</connectionStrings> 

public class ProjectEntity : DbContext 
 { 
  public DbSet<NewsEntity> NewsEntity { get; set; } 
 } 

ProjectEntity PE = new ProjectEntity(); 
  public ActionResult News() 
  { 
   try 
   { 
    var list = PE.NewsEntity.ToList(); 
    return View(list); 
   } 
   catch (Exception e) 
   { 
    throw e; 
   } 
  } 

@model IEnumerable<TaiQiu.Models.NewsEntity> 
@{ 
 ViewBag.Title = "后台新闻管理列表"; 
 Layout = "~/Views/Shared/_MLayout.cshtml"; 
} 
<h2> 
 新闻列表</h2> 
<p> 
 @Html.ActionLink("添加", "Create") 
</p> 
<table> 
 <tr> 
  <th width="50px"> 
   ID 
  </th> 
  <th width="300px"> 
   标题 
  </th> 
  <th width="150px"> 
   时间 
  </th> 
  <th> 
  </th> 
 </tr> 
 @foreach (var item in Model) 
 { 
  <tr> 
   <td> 
    @Html.DisplayFor(modelItem => item.NId) 
   </td> 
   <td> 
    @Html.DisplayFor(modelItem => item.Title) 
   </td> 
   <td> 
    @Html.DisplayFor(modelItem => item.Time) 
   </td> 
   <td> 
    @Html.ActionLink("编辑", "EditNews", new { id = item.NId }) | 
    @Html.ActionLink("删除", "DeleteNews", new { id=item.NId }) 
   </td> 
  </tr> 
 } 
</table> 

[HttpPost] 
  [ValidateInput(false)] 
  public ActionResult Create(NewsEntity news) 
  { 
   if (ModelState.IsValid) 
   { 
    news.Time = DateTime.Now; 
    PE.NewsEntity.Add(news); 
    try 
    { 
     PE.SaveChanges(); 
     return RedirectToAction("News"); 
    } 
    catch (Exception e) 
    { 
     throw e; 
    } 
 
   } 
   return View(); 
  } 

@model TaiQiu.Models.NewsEntity 
@{ 
 ViewBag.Title = "添加新闻"; 
 Layout = "~/Views/Shared/_MLayout.cshtml"; 
} 
<h2> 
 添加新闻</h2> 
<script src="/UploadFiles/2021-04-02/@Url.Content(">

修改页面一样，Controller稍微有点修改：


[HttpPost] 
  [ValidateInput(false)] 
  public ActionResult EditNews(NewsEntity news) 
  { 
   if (ModelState.IsValid) 
   { 
    news.Time = DateTime.Now; 
    PE.Entry(news).State = EntityState.Modified;//修改 
    PE.SaveChanges(); 
    return RedirectToAction("News"); 
   } 
   return View(news); 
  } 



删除Controller代码：


public ActionResult DeleteNews(int id) 
  { 
   var model = PE.NewsEntity.Find(id); 
   PE.NewsEntity.Remove(model); 
   PE.SaveChanges(); 
   return RedirectToAction("News"); 
  } 



小编刚接触MVC3,本文也只是本人学习中的一点点积累，有很多不好的地方，希望大家多提意思。