public List<Post> getPosts(int Limit, int From)
{
if (Limit > 0)
{
if (From > 0)
{
//posts = post.getPosts(Limit, From);
using (var ctx = new PostContext())
{
string postGetPostQueryCustom =
"SELECT * " +
"FROM POSTS " +
"where postid < " + From.ToString() + " " +
"ORDER BY PostDate desc " +
"OFFSET 0 ROWS " +
"FETCH NEXT " + Limit.ToString() + " ROWS ONLY";
List<Post> postlist = ctx.Posts.SqlQuery(postGetPostQueryCustom).ToList();
return postlist;
}
}
else
{
//posts = post.getPosts(Limit, 0);
using (var ctx = new PostContext())
{
string postGetPostQueryCustom =
"SELECT * " +
"FROM POSTS " +
"ORDER BY PostDate desc " +
"OFFSET 0 ROWS " +
"FETCH NEXT " + Limit.ToString() + " ROWS ONLY";
List<Post> postlist = ctx.Posts.SqlQuery(postGetPostQueryCustom).ToList();
return postlist;
}
}
}
else
{
using (var ctx = new PostContext())
{
string postGetPostQueryCustom =
"SELECT * " +
"FROM POSTS " +
"ORDER BY PostDate desc";
List<Post> postlist = ctx.Posts.SqlQuery(postGetPostQueryCustom).ToList();
return postlist;
}
}
}