EF Lanbda表达式

var v = db.Users.Select(e => e);  //查询所有
var v = db.Users.Select(e => new {  e.UserName,  e.UserPwd });  //查询users中的UserName,UserPwd
var v = db.Users.Select(e => new { name = e.UserName, pwd = e.UserPwd });  //查询users中的UserName,UserPwd,并取别名
var v = db.Users.Select(e=>e.UserPwd).Distinct();  //去掉重复数据
var v = db.Users.Where(e=>(e.UserName=="金双林"));   //查询users中UserName为‘金双林’的所以记录
var v = db.Users.Where(e=>(e.UserName=="小丽"&&e.UserSex=="女"));  //查询UserName为‘小丽’，且UserSex为‘男’的记录
var v = db.Users.Where(e=>(e.UserAge>=22&&e.UserAge<=30)); //查询UserAge大于22小于30的所以记录
var v = db.Users.Where(e => (e.UserAge >= 22 && e.UserAge <= 30)).OrderByDescending(e => e.UserAge); //查询UserAge大于22小于30的所以记录,倒序排序
var v = db.Users.OrderBy(e=>e.UserAge); //按升序排序
var v = db.Users.OrderBy(e => e.UserAge).ThenBy(e=>e.UserId); //年龄按升序排序,相同，则按UserId升序排序
var v = db.Users.OrderBy(e => e.UserAge).OrderByDescending(e=>e.UserId);
var v = db.Users.Where(e=>e.UserName.StartsWith("小")||e.UserName.Substring(0,2)=="ad"); //查询用户名以‘小’开头，和以‘ad’开头的数据
var v = db.Users.Sum(e=>e.UserAge);  //查询年龄最大的记录 返回int类型；
var v = db.Users.Count();       //返回总记录行数  
 var v = db.Users.GroupBy(e => e.UserSex).Select(a => new { name=a.Key,age = a.Sum(e=>(Int32)(e.UserAge)) });  //按性别分组，取年龄最大值
var v = db.Users.SelectMany(R => be.Role, (U, R) => new { U = U, R = R });
var v = db.Users.Join(be.Role, u => u.UserId, r => r.UserId, (u, r) => new {u=u,r=r });

此文章不错。笔者整理了下，望参考。