How Do I Use .Take() Method In A Loop To Take Records In Batches

Question

2.67/5 (2 votes)

See more:

Hello everyone,

I have a list item the contains a thousands records, i am required to push these records to a web service in a batch of 5 records per time/iteration, i.e. 1-5 records in the first iteration the 6-10,11-15,16-20. etc. i am passing the list as an argument to a method.

C#

var postData = new DataImportClient();
postData.postDocumentAttribute(cdAttrlist.Take(5).ToArray());

Please is there anyway this can be achieved or is there sql statement i can use while retrieving the records to achieve this

Posted 27-Jun-14 5:00am

Uwakpeter

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Fitim Skenderi · Answer 1 · 2014-06-27T06:36:00

Solution 1

You need to use Skip() and Take() in tandem.

so you would have something along the lines :

C#

public IEnumerable<string> GetValues(int pageIndex)
{
    return cdAttrlist.Skip(pageIndex * 5).Take(5).ToArray();
}</string>

Posted 27-Jun-14 6:36am

Fitim Skenderi

Comments

Uwakpeter 30-Jun-14 4:59am

I have this: var postData = new DataImportClient();
postData.postDocumentAttribute(cdAttrlist.Take(5).ToArray()); in a foreach loop, how do i call this method in the foreach loop? cdAttrlist has to be in the foreach loop for it to bind all records.

Matt T Heffron 30-Jun-14 13:19pm

This is **VERY** inefficient.
See my article I reference in my Solution 2 for why it is inefficient and how to do it well.

Matt T Heffron · Answer 2 · 2014-06-30T07:18:00

Solution 2

See my article: Considerations on Efficient use of LINQ Extension Methods[^] where my example task is exactly this.

Posted 30-Jun-14 7:18am

Matt T Heffron

Comments

Uwakpeter 1-Jul-14 4:52am

Thanks sir for your contributions, your solution was pretty long, but i have been to implement it, i use offset and fetch next keywords in sql server 2012 to do it.