select every 5 records with LINQ

Question

is there a way to select one per every 5 records in sql server with linq?

Answer 1

.Skip(5).Take(1);

If you want a more descriptive answer then please post your code.

Answer 2

I don't think it's possible to do server side directly with LINQ to SQL. There is a client side solution, however:

 var result = new DataContext().Table.AsEnumerable()
                     .Select((x, i) => new { Index = i, Item = x })
                     .Where(t => t.Index % 5 == 0).Select(t => t.Item);