Entity Frameworkshi 微软包含的一个实体框架，支持开发人员通过对概念性应用程序模型编程来创建数据访问应用程序，可以降低面向数据的应用程序所需的代码量并减轻维护工作。

1、简单的查询

  public JsonResult ArticleList()

        {

            var articleQuery = lvXingContext.Articles.AsNoTracking().AsQueryable();

            var articleList = articleQuery.ThenByDescending(p =>   p.CreateTime).Future();//根据时间排序

            CommonResult commonResult = new CommonResult();

            commonResult.Flag = true;

            commonResult.Data = articleList;

            return Json(commonResult);

        }

2、添加对象

 public JsonResult DoAdd(Article article)

        {

            CommonResult commonResult = new CommonResult();

            article.Id = CommonHelper.GenerateRandomId();

            article.CreateTime = DateTime.Now;

            lvXingContext.Articles.Add(article);

            if (lvXingContext.SaveChanges() > 0)

            {

                commonResult.Data = "";

                commonResult.Flag = true;

                commonResult.Message = "添加成功";

            }

            else

            {

                commonResult.Data = "";

                commonResult.Flag = false;

                commonResult.Message = "添加失败";

            }

            Json(commonResult);

        }

3、编辑对象

   public JsonResult DoEdit(Article article)

        {

            CommonResult commonResult = new CommonResult();

            lvXingContext.Articles.Where(p => p.Id == article.Id).Update(p => new Models.Article

            {

                Title = article.Title,

                Abstract = article.Abstract,

                Author = article.Author,

                Content = article.Content,

                IsTuiSong = article.IsTuiSong,

                SlImgUrl = article.SlImgUrl,

                Type = article.Type,

                ContentType = article.ContentType,

            });

            commonResult.Data = "";

            commonResult.Flag = true;

            commonResult.Message = "编辑成功";

            return Json(commonResult);

        }

4、删除对象

     public JsonResult DoDelete(string id)

        {

            CommonResult commonResult = new CommonResult();

            lvXingContext.Articles.Where(p => id.Contains(p.Id)).Delete();

            commonResult.Data = "";

            commonResult.Flag = true;

            commonResult.Message = "删除成功";

            return Json(commonResult);

        }

    它使得我们的通用数据库交互变得简单易行，并且完全不用考虑SQL语句。

诚信工作室   供稿