c# Robust Ling Idea

David Smith

I am trying to come up a link to process or get 3 messages at a time in the color table below. In the color table below I 8 records. There will be 3 gets, the last get will only 2 records. So we want to account for the remaining records. Is there a linq that can handle this logic I am trying to achieve. Once I get the record in batches of 3's I go do something with the batch

Color Table:

ID | Item

1 | red

2 | blue

3 | green

4 | brown

5 | purple

6 | yellow

7 | orange

8 | violet

4 Replies

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

Tapan Patel9y ago
Accepted answer
I have a class called Program and it contains the memeber (list of ints- not a good idea but for demo, I am good with it).
public class Program
{
public List<int> IDs;
}
and later using the same class, I am creating list of 8 integers and getting it as below in set of 3 each time except last one will have just two records.
px.IDs.AddRange(Enumerable.Range(1, 8));
            int totalRecs = px.IDs.Count;
            for (int i = 1; i <= totalRecs; i+=3)
            {
                var list =Enumerable.Range(i, 3);
                var results = px.IDs.Where(obj => list.Contains(obj));


            }
Or you can use Skip/Take combination for getting the expected result.
for (int i = 3; i <= totalRecs+1; i+=3)
{
    var output = px.IDs.Take(i).Skip(i - 3);
}
0
David Smith9y ago
Ok requirements have change. I am going to start a new thread. The solution you put below works
0
David Smith9y ago
Can you give me an example. I'm a visual learner
+1
Amit Gupta9y ago
You can use skip and take function to achieve your task

Have a look to the below reference:
http://www.c-sharpcorner.com/UploadFile/3d39b4/take-and-skip-operator-in-linq-to-sql/
0