//查询 var data1 = base.GetById(1); //根据 id 查询 var data2 = base.GetList(); //查询所有 var data3 = base.GetList(it => it.Id == 1); //TOP1 条件 var data4 = base.GetSingle(it => it.Id == 1); //查询单条记录,结果集不能超过 1,不然会提示错误 var data = base.GetFirst(it => it.Id == 1); //查询第一条记录 var p = new PageModel() { PageIndex = 1, PageSize = 2 }; var data5 = base.GetPageList(it => it.Name == "xx", p); Console.Write(p.PageCount); var data6 = base.GetPageList(it => it.Name == "xx", p, it => it.Name, OrderByType.Asc); Console.Write(p.PageCount); List<IConditionalModel> conModels = new List<IConditionalModel>(); conModels.Add(new ConditionalModel(){FieldName="id",ConditionalType=ConditionalType.Equal,FieldValue="1"});//id=1 var data7 = base.GetPageList(conModels, p, it => it.Name, OrderByType.Asc); var data8 = base.AsQueryable().Where(x => x.Id == 1).ToList();//使用 Queryable
//插入 base.Insert(insertObj); base.InsertRange(InsertObjs); var id = base.InsertReturnIdentity(insertObj); //插入返回自增 var SnowflakeId=InsertReturnSnowflakeId(insertObj); //插入返回雪花 ID base.AsInsertable(insertObj).ExecuteCommand(); //复杂功能使用 Insertable