public IHttpActionResult Get() { using (ApplicationDbContext db = new ApplicationDbContext()) { List <PostViewModel> posts = new List <PostViewModel>(); foreach (var x in db.Posts.ToList()) { PostViewModel pvm = ApplicationUtils.CreatePostViewModel(x); pvm.Likes = 0; pvm.Dislikes = 0; pvm.Likes = db.Database.SqlQuery <int>("SELECT COUNT(*) FROM Users_Posts_Like WHERE Post_id = {0}", pvm.Id).First(); pvm.Dislikes = db.Database.SqlQuery <int>("SELECT COUNT(*) FROM Users_Posts_Dislike WHERE Post_id = {0}", pvm.Id).First(); posts.Add(pvm); } return(Ok(new { Posts = posts })); } }