public List <ArticleFromCategoryId> GetArticleFromCategoryViewModel(long categoryid, int num)
{
string sql = @" select c.ArticleID,c.Title,d.ArticleText,c.CategoryID,c.ImgUrl from NewsArticles as c join [NewsArticleText] as d on c.ArticleID=d.ArticleID where c.CategoryID=@categoryid order by c.ArticleID desc offset 0 row fetch next @num rows only";
return(_dapperContext.Query <ArticleFromCategoryId>(sql, new { categoryid = categoryid, num = num }).ToList());
}