var q = from c in db.student where c.Name == "dd" select c; var q1 = db.student.First(c => c.Age == "111"); var q2 = from c in db.student select c.Name; var q3 = from c in db.student select new { c.Name, c.Age }; var q4 = db.student.Count(); var q5 = db.student.Count(c => c.Name == "dd"); var q6 = db.student.LongCount(); var q7 = db.student.Select(c => c.Id).Sum(); //Sum/Min/Max/Avg var q8 = db.student.Sum(c => c.Id); var q9 = from c in db.student orderby c.Id select c; var q10 = from c in db.student where c.Name == "77" orderby c.Id select c; var q11 = from c in db.student orderby c.Id descending select c;//降序排序 descending var q12 = from c in db.student orderby c.Id, c.Name select c;
linq to sql
最新推荐文章于 2023-08-06 12:39:16 发布