public UserTweetsVM GetTweet(int tweetID) { UserTweetsVM obj = db.tsp_GetTweet(tweetID).Select(x => new UserTweetsVM { content = x.Content, datetime = (DateTime)x.TweetDate, likeCount = (int)x.likeCount, nickname = x.Nickname, parentTweetUsername = x.ParentTweetUsername, profileImg = x.ProfileImage, retweetCount = (int)x.retweetCount, tweetID = (int)x.TweetID, userID = (int)x.UserID, imgTweet = x.TweetImg, username = x.Username }).SingleOrDefault(); foreach (var item in db.tsp_ReplyCount().ToList()) { if (obj.tweetID == item.TweetID) { obj.replyCount = (int)item.ReplyCount; break; } } return(obj); }