public string Lookup(string searchData, string searchField, string returnField) { // checks if the search field contains the search data and returns the return field data, no match returns null if (searchData != null)// && searchData.Equals(GetByField(searchField), StringComparison.CurrentCultureIgnoreCase)) { DefaultConnectionEntities db = new DefaultConnectionEntities(); Reaction reaction; switch (searchField) { case "Object": reaction = (from u in db.Reactions where u.Object == searchData select u).FirstOrDefault(); break; case "Mood": reaction = (from u in db.Reactions where u.Mood == searchData select u).FirstOrDefault(); break; case "Action": reaction = (from u in db.Reactions where u.Action == searchData select u).FirstOrDefault(); break; case "Emoji": reaction = (from u in db.Reactions where u.Emoji == searchData select u).FirstOrDefault(); break; default: return(null); } return(reaction.GetByField(returnField)); } return(null); }