# CoreSolution.Dapper

**Repository Path**: wenjungg/CoreSolution.Dapper

## Basic Information

- **Project Name**: CoreSolution.Dapper
- **Description**: Dapper Hell Yeah
- **Primary Language**: C#
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 2
- **Forks**: 0
- **Created**: 2019-10-22
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

 
### **CoreSolution.Dapper, Hell Yeah!**
- ###### 参照EF 提交方式，自己组装lambda
``` sh
 - 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);