SqlHelper简单实现（通过Expression和反射）10.使用方式

以下是整个SqlHelper的Demo：

        public Result<List<ArticleDTO>> GetIndexArticleList(int count, int userID)
        {
            var exp = DbUtilityFactory.GetDbUtility().GetSqlExpression<ArticleEntity>();
            exp.Where(a => a.userID == userID);
            exp.OrderByDescending(a=>a.articleDate);
            var data = DbUtilityFactory.GetDbUtility().Paged<ArticleEntity>(a=>a.articleDate,1,6);
            if(data.Any())
            {
                return new Result<List<ArticleDTO>>()
                {
                    IsSuccess = true,
                    ReturnMessage = "成功",
                    ReturnValue = data.Select<ArticleEntity, ArticleDTO>(a => new ArticleDTO()
                    {
                        articleAbstract = a.articleAbstract,
                        articleDate = a.articleDate,
                        articleID = a.articleID,
                        articleTitle = a.articleTitle
                    }).ToList()
                };
            }else
            {
                return new Result<List<ArticleDTO>>()
                {
                    IsSuccess = false,
                    ReturnMessage = "没有记录"
                };
            }
        }

 比如在运行到第5行exp.OrderByDescending(a=>a.articleDate)时：

这里就是实现了Lambda到sql的转换。

完整Demo地址：https://github.com/Racpheal/Construction.git