how to take first 10 record using LINQ ?

Abhilash J A

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 ?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Munesh Sharma9y ago
var list = (from t in ctn.Items
where t.DeliverySelection == true && t.Delivery.SentForDelivery == null
orderby t.Delivery.SubmissionDate
select t).Take(10);
+1
Ramesh Palanivel9y ago
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;
0
Abhilash J A9y ago
@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'.
0
Ramesh Palanivel9y ago
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();
0