linq随笔(一)

分页：
TestDataDataContext db=new TestDataDataContext();

var un = from m in db.TestTable2.Skip(1).Take(10) select m;

Skip开始，take结束

 

抓取linq查询结果集内容分解:

foreach(TestTable2 t2 in un)
{
     TestTable2 tt = new TestTable2();
     tt.context = t2.test1.ToString();
     tt.test1 = t2.context.ToString();
     lt.Add(tt);
}