public static List<UserProfile> GetUserProfileSearch(string searchTerm)
{
using (CarrotCMSDataContext _db = CarrotCMSDataContext.Create()) {
return (from u in _db.membership_Users
join ud1 in _db.carrot_UserDatas on u.Id equals ud1.UserKey into ud2
from ud in ud2.DefaultIfEmpty()
where u.UserName.Contains(searchTerm)
|| u.Email.Contains(searchTerm)
select new UserProfile(u, ud)).Take(100).ToList();
}
}