public IList <Guid> getCustomerActivity(int count) { using (var context = new CustomerActivityContext()) { var guidList = (IList <Guid>)(from ca in context.BrandBuyClickList orderby ca.CreationDate descending select ca.CustomerActivity_ID).Take(count).ToList(); return(guidList); } }
public IList <Guid> GetCustomerActivity(int count) { using (var context = new CustomerActivityContext()) { var guidList1 = (IList <Guid>)(context.BrandBuyClickList.Where(p => p.CustomerActivity_ID != Guid.Empty) .OrderByDescending(c => c.CreationDate).Select(d => d.CustomerActivity_ID).Distinct().Take(count) .ToList()); //var guidList = (IList<Guid>) (from ca in context.BrandBuyClickList // orderby ca.CreationDate descending // select ca.CustomerActivity_ID).Distinct().Take(count).ToList() //where ca.CustomerActivity_ID<> Guid.Empty; return(guidList1); } }