C#代码
- //根据条件获取数据行数
- int _Count = (Entities.User.userName == "abc" & Entities.User.password == "123123").Count<Entities.User>();
- //根据主键获取单个实体
- Entities.User item = DBContext.Load<Entities.User>(1);
- //使用条件获取单个实体
- item = (Entities.User.userName == "abc").ListFirst<Entities.User>();
- //添加一行
- DBContext.Add(item);
- //获取整个表的数据
- IList<Entities.User> items = new Expression().List<Entities.User>();
- //修改多个字段值
- (Entities.User.iD == 1).Edit<Entities.User>(o => { o.UserName = "abcd"; o.Email = "sov@163.com"; });
- //只更新实体改过的字段
- item = DBContext.Load<Entities.User>(1);
- item.Password = "321321";
- DBContext.Save(item);
- //按条件删除数据
- (Entities.User.iD == 1).Delete<Entities.User>();
- //按条件获取分页
- Expression exp = new Expression();
- exp &= Entities.User.userName.IsNull() | Entities.User.password == "";
- IList<Entities.User> userItems = exp.List<Entities.User>(new Region(0, 20), Entities.User.iD.Desc);
