public List <TitleList> SearchTitles(string whrSQLquery) { var _context = new DeluxeOrderManagementEntities(); var titles = _context.usp_Search_Title(whrSQLquery).Select(x => new TitleList { TitleName = x.TitleName, vendorID = x.VendorId, VIDType = x.VIDStatus, Territory = x.AppleTerritory, ApplePOESTStartDate = x.POESTStartDate, AppleESTStartDate = x.ESTStartDate, AppleESTEndDate = x.ESTEndDate, ESTHDLiveStatus = x.LiveESTHD, ESTSDLiveStatus = x.LiveESTSD, AppleVODStartDate = x.VODStartDate, AppleVODEndDate = x.VODEndDate, VODHDLiveStatus = x.LiveVODHD, VODSDLiveStatus = x.LiveVODSD, AnnouncementPOESTStartDate = x.AnnPOESTStartDate, AnnouncementESTStartDate = x.AnnESTStartDate, AnnouncementESTEndDate = x.AnnESTEndDate, AnnouncementVODStartDate = x.AnnVODStartDate, AnnouncementVODEndDate = x.AnnVODEndDate, ComponentType = x.ComponentType, ComponentQuality = x.ComponentQuality, Language = x.LanguageName, LanguageType = x.LanguageType, LanguageStatus = x.LanguageStatus }).Distinct().ToList(); return(titles); }