先建表
接着建立ADO.NET实体数据模型
接着搭建好DAL和BLL
DAL如下:
1.ArticleDAO.cs
public class ArticleDAO
{
/// <summary>
/// 查询所有的文章信息
/// </summary>
/// <returns></returns>
public List<Article> Select()
{
MyDBEntities db = new MyDBEntities();
return db.Article.Select(a=>a).ToList();
}
/// <summary>
/// 根据id查找文章
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Article Select(int id)
{
MyDBEntities db = new MyDBEntities();
return db.Article.Where(p=>p.Id==id).FirstOrDefault();
}
/// <summary>
/// 添加文章
/// </summary>
/// <param name="article"></param>
/// <returns></returns>
public int Add(Article arti