public Task <List <School> > ListAllENV2(int skip, int take, string orderBy, string direction = "DESC", string search = "")
{
var articles = Task.FromResult(_dapperManager.GetAllENV2 <School>
($"SELECT * FROM [Schools] WHERE SchoolName like '%{search}%' ORDER BY {orderBy} {direction} OFFSET {skip} ROWS FETCH NEXT {take} ROWS ONLY; ", null, commandType: CommandType.Text));
return(articles);
}