CoreSolution.Dapper, Hell Yeah!

• 参照EF 提交方式，自己组装lambda

 - IUserServices _IUserServices = new UserServices();

 - var Result1=_IUserServices.Where(t => t.UserName == "lwj").OrderBy(t => t.UserName).Skip(0).Take(3).ToList();

查询

• var Result2= _IUserServices.Where(t => t.UserName == "lwj").OrderBy(t => t.UserName).Skip(0).Take(3).ToList();

• ar Result3=_IUserServices.FirstOrDefault(t=>t.UserName=="lwj"&&t.IsDelete);

• var Result4=_IUserServices.Where(t => t.UserName == "lwj").ToList();

查询Selector 推荐匿名方式

• ToList Selector T

• var Result5 = _IUserServices.Where(t => t.UserName == "lwj").OrderBy(t => t.UserName).Skip(0).Take(3).Select(t => new UserInfo() { Id = t.Id, UserName = t.UserName }).ToList();

• ToList Selector T1

• var Result6 = _IUserServices.Where(t => t.UserName == "lwj").OrderBy(t => t.UserName).Skip(0).Take(3).Select(t => new _VUserInfo() { Id = t.Id, UserName = t.UserName }).ToList<_VUserInfo>();

• ToList Selector 匿名(推荐，清爽)

• var Result7 = _IUserServices.Where(t => t.UserName == "lwj").OrderBy(t => t.UserName).Skip(0).Take(3).Select(t => new { Id = t.Id, UserName = t.UserName }).ToList<_VUserInfo>();

更新 推荐Selector

• 全量更新操作

• var idd =Guid.Parse("9E88E4C1-E47F-44FE-B028-27AB646CF6F3");

• var updateNum=_IUserServices.Update(new UserInfo() { Id= idd, UserAge = 12, UserName = "lwj12",});

• _IUserServices.SaveChange(updateNum);

• 更新操作 Selector 推荐

• var updateSelectorNum = _IUserServices.Update(t=>new UserInfo() { Id= idd, UserName="lewisCon" });

• _IUserServices.SaveChange(updateSelectorNum);

添加

• var addNum = _IUserServices.Add(new UserInfo() {Id=Guid.NewGuid(), UserAge=22, UserName="lewis", UserSex=true });

• _IUserServices.SaveChange(addNum);

删除

• 更新操作 delete(Guid)

• var deleteNum=_IUserServices.Delete(Guid.Parse("FBE55EE3-8AD5-46BC-BEBD-F04A8A37BC09"));

• _IUserServices.SaveChange(deleteNum);

• 更新操作 delete(Model)

• var id = Guid.Parse("9E88E4C1-E47F-44FE-B028-27AB646CF6F3");

• var firstModelDefault=_IUserServices.FirstOrDefault(t => t.Id == id);

• var deleteModelNum = _IUserServices.Delete(firstModelDefault);

• _IUserServices.SaveChange(deleteModelNum);

• 删除操作 remove(Guid)

• var removeNum=_IUserServices.Remove(Guid.Parse("23FD0BB1-44BF-455B-9C3F-32F10DE90BE6"));

• _IUserServices.SaveChange(removeNum);