c# Robust Ling Idea

Question

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