how to take first 10 record using LINQ ?

Question

Hello,

If there is have more than 10 records, then take only 10,

var query = from a in context.Advertisements where a.idPartner == partnerid select a;
count = query.Count();
if (count > 10)
return (query.Skip(startIndex).Take(10).ToList());
else
return query.ToList();

now the error occured,

The method 'Skip' is only supported for sorted input in LINQ to Entities. The method 'OrderBy' must be called before the method 'Skip'.

Then I have tried, this code:

return (query.OrderBy(p=>p.idAdvertisement).Skip(startIndex).Take(10).ToList());

But here occurred another error,

Incorrect syntax near 'OFFSET'.
Invalid usage of the option NEXT in the FETCH statement.

How can I solve this ?

Munesh Sharma · Answer

var list = (from t in ctn.Items where t.DeliverySelection == true && t.Delivery.SentForDelivery == null orderby t.Delivery.SubmissionDate select t).Take(10);

Ramesh Palanivel · Answer

Hi Manikandan, I have used this code, try this it may help you!.. Its worked for me List designation = _entity.M_DESIGNATION.Where(x => x.DESIGNATION_ACTIVE.ToUpper() == "Y").Select(des => new M_Designation { DesignationId = des.DESIGNATION_ID, DesignationCode = des.CODE, DesignationName = des.NAME }).ToList(); //List designation = (from des in _entity.M_DESIGNATION select des).ToList(); records.Content = (from desig in designation select desig).Skip((page - 1) * 15) .Take(15).ToList().AsQueryable (); records.TotalRecords = (from designationrecords in _entity.M_DESIGNATION select designationrecords).Count(); records.PageSize = 5;

Abhilash J A · Answer

@Ramesh stille this error occurring : The method 'Skip' is only supported for sorted input in LINQ to Entities. The method 'OrderBy' must be called before the method 'Skip'.

Ramesh Palanivel · Answer

Hi manikandan, Try this query, var query = from a in context.Advertisements where a.idPartner == partnerid select a; count = query.Count(); if (count > 10) return Queryable.Skip(query,startIndex).Take(10).ToList()); else return query.ToList();