IEnumerable<Orders> page = db.Orders
.OrderBy( o => o.OrderDate )
.Skip( pageIndex * pageSize )
.Take( pageSize )
Another sample would be a question they asked on forums:create table tickdata (timed datetime, price money, quantity int) insert into tickData values ('06:01',100,20) insert into tickData values ('06:02',90,30) insert into tickData values ('06:03',129,10) insert into tickData values ('06:07',117,20) insert into tickData values ('06:11',112,8) insert into tickData values ('06:12',150,60) insert into tickData values ('06:20',110,10) insert into tickData values ('06:23',120,5) insert into tickData values ('06:24:59',130,15) insert into tickData values ('06:25',140,35)From this data we need something like a stocks listing in 5 minutes intervals, listing should start and stop based on min-max times recorded. Something like (for the data abaove):
var result = from myData in Tickdatas.OrderBy( t => t.Timed ).AsEnumerable() group myData by ((int)myData.Timed.Value.TimeOfDay.TotalMinutes) / 5 into barData let bStart = TimeSpan.FromMinutes( barData.Key * 5 ).ToString() let bEnd = TimeSpan.FromMinutes( (barData.Key+1) * 5 ).ToString() select new { period = bStart.Substring(0,5) + " - " + bEnd.Substring(0,5), open = barData.FirstOrDefault().Price, low = barData.Min( bd => bd.Price ), high = barData.Max( bd => bd.Price ), close = barData.LastOrDefault().Price, volume = barData.Sum( bd => bd.Quantity ) }Samples are endless. Would you show me how would these be w/o Linq so I can see that L2S didn't solve anything too.