c#学习记录（1）——Linq to sql

Linq的使用

首先在数据库中建两张表，class和student，表截图如下：
student

classes

命名空间

System.Linq;

1.简单查询

sql语句：

select * from student where age=15 order by name ASC,birthday DESC 

linq：

from s in db.student
where s.age == 15 
orderby s.name,s.birthday descending
select s

扩展方法：

db.student.Where(s=>s.age==15).OrderBy(s=>s.name).ThenByDescending(s=>s.birthday).Select(s=>s)

2.分组

sql语句：

select age,count(*) number from student group by age having count(*)>3 order by count(*) desc 

linq：

from s in db.student
group s by s.age into g
where g.Count()>3
orderby g.Count() descending
select new {
   
           Age