var result = from r in lqDB.table1
orderby r.id descending //当要获取最后一条数据时就重新排序下再取第一条
select r;
table1 t = result.First();
Label1.Text = t.id;
Label2.Text = t.name;
.
.
orderby r.id descending //当要获取最后一条数据时就重新排序下再取第一条
select r;
table1 t = result.First();
Label1.Text = t.id;
Label2.Text = t.name;
.
.
.