/// <summary> /// This method retrieves the information to index a stored procedure /// and the retrives information is encapsulated in DTO /// </summary> /// <returns></returns> public List <IndexDataDto> GetDataForIndex() { var lReturn = new List <IndexDataDto>(); using (mifnexsoEntities = new MIFNEXSOEntities()) { lReturn = (from a in mifnexsoEntities.spGetDataIndex() select new IndexDataDto { objectId = a.ObjectId.GetValueOrDefault(Guid.Empty), title = a.Title, organizationName = a.OrganizationName, scoreValue = a.ScoreValue.GetValueOrDefault(1), fullRequest = a.FullText, keywords = a.Keywords, sentences = a.Sentences, concepts = a.ConceptsMember, language = a.Language, category = a.Category, key = a.keys, label = a.Label, country = a.Country, region = a.Region, city = a.City }).ToList(); } return(lReturn); }