How can I get the following items from a list with entity framework?

Question

I have a very large list and I want to extract in parts of 50 items for which I will implement the following:

try
{
    using (var context = new ccoFinalEntities())
    {
        return context.sales
            .Where(p => true == p.status && myID == p.id)
            .Take(50)
            .ToList();
    }
}
catch
{
    return null;
}

I assume this will return me the first 50 items, my question is:

How can I get the next 50 and so on until extract the list completely?

Any comments or suggestions are welcome

FIrst time you call `return`, your method will exit and you will need to cal the method again. — Matt, Aug 23 '19 at 12:46
Use Select(x,i) => where 'i' is the index. Then use GroupBy i/50 to get groups of 50. — jdweng, Aug 23 '19 at 12:50

score 1 · Accepted Answer · answered Aug 23 '19 at 12:51

1

public List<Item> GetDate(int page, int size = 50)
    {
    try
    {
      using (var context = new ccoFinalEntities())
      {
        return context.sales.Where(p => true == p.status && myID == p.id)
                            .Skip(page * size).Take(size).ToList();
      }
    }
    catch
    {
      return null;
    }
}

Then call:

GetData(0);
GetData(1);
GetData(2);
GetData(3);

.....

Skip ignore first page * size (1 * 50, 2 * 50, ...) items and Take size (50) item

answered Aug 23 '19 at 12:51

Antoine V

6,998
2
11
34

"The operation cannot be completed because the DbContext has been disposed." – Fabián Romo Aug 23 '19 at 13:03
@FabiánRomo Impossible. Make sure you call `ToList()` before disposing and make sure you eager load reference properties. – Silvermind Aug 23 '19 at 13:05
"The method 'Skip' is only supported for sorted input in LINQ to Entites. The methos 'OrderBy' must be called before the methos 'Skip'" – Fabián Romo Aug 23 '19 at 13:18

How can I get the following items from a list with entity framework?

1 Answers1