public List <UserTweetsVM> SearchTweets(string word) { List <UserTweetsVM> lista = db.tsp_AllTweetsEveryone().Select(x => new UserTweetsVM { userID = (int)x.UserID, content = x.Content, datetime = (DateTime)x.TweetDate, likeCount = (int)x.likeCount, imgTweet = x.TweetImg, nickname = x.Nickname, profileImg = x.ProfileImage, retweetCount = (int)x.retweetCount, username = x.Username, tweetID = (int)x.TweetID, parentTweetUsername = x.ParentTweetUsername }).ToList(); foreach (var item in db.tsp_ReplyCount().ToList()) { foreach (var tweet in lista) { if (tweet.tweetID == item.TweetID) { tweet.replyCount = (int)item.ReplyCount; break; } } } List <UserTweetsVM> lista2 = new List <UserTweetsVM>(); foreach (UserTweetsVM item in lista) { try { if (item.content.Contains(word)) { lista2.Add(item); } } catch (Exception e) { } } return(lista2); }