var list=db.Queryable<Test>()
          .Includes(x => x.Provinces,x=>x.Citys ,x=>x.Street)//多級(jí)查詢(xún) 有時(shí)候VS沒(méi)提示手寫(xiě)
          .Includes(x => x.ClassInfo)// 一級(jí)查詢(xún)
          .ToList();
                 
       //多級(jí)查詢(xún)  加排序過(guò)濾
       .Includes(x =>x.Provinces.Where(z=>z.Id>0).OrderBy(z=>z.Id).ToList(),x=>x.Citys,x=>x.Street)
        // 一級(jí)查詢(xún)
       .Includes(x =>x.ClassInfo)
       .ToList();

//實(shí)體
        public class StudentA
        {
            [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
            public int StudentId { get; set; }
            public string Name { get; set; }
            public int SchoolId { get; set; }
            [Navigate(NavigateType.OneToOne, nameof(SchoolId))]//一對(duì)一
            public SchoolA SchoolA { get; set; }
  
        }
        public class SchoolA
        {
            [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
            public int SchoolId { get; set; }
            public string SchoolName { get; set; } 
        }
//代碼
 var list2 = db.Queryable<StudentA>()
           .Includes(x => x.SchoolA)
           .Where(x => x.SchoolA.SchoolName == "北大")//可以對(duì)一級(jí)導(dǎo)航進(jìn)行過(guò)濾
           .ToList();

//實(shí)體
        public class StudentA
        {
            [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
            public int StudentId { get; set; }
            public string Name { get; set; }
            public int SchoolId { get; set; }
            [Navigate(NavigateType.OneToOne, nameof(SchoolId))]//一對(duì)一
            public SchoolA SchoolA { get; set; }
  
        }
        public class SchoolA
            public string SchoolName { get; set; } 
//代碼
 var list2 = db.Queryable<StudentA>()
           .Includes(x => x.SchoolA)
           .Where(x => x.SchoolA.SchoolName == "北大")//可以對(duì)一級(jí)導(dǎo)航進(jìn)行過(guò)濾
           .ToList();

//多對(duì)多
       public class ABMapping1
       {
            [SugarColumn(IsPrimaryKey = true )]
            public int AId { get; set; }
            [SugarColumn(IsPrimaryKey = true)]
            public int BId { get; set; }
        }
        public class A1
        {
            [SugarColumn(IsPrimaryKey = true, IsIdentity = true  )]
            public int Id { get; set; }
            public string Name { get; set; }
            [Navigate(typeof(ABMapping1),nameof(ABMapping1.AId),nameof(ABMapping1.BId))]
            public List<B1> BList { get; set; }
        }
        public class B1
        {
            [SugarColumn(IsPrimaryKey = true , IsIdentity = true)]
            public int Id { get; set; }
            public string Name { get; set; }
            [Navigate(typeof(ABMapping1), nameof(ABMapping1.BId), nameof(ABMapping1.AId))]
            public List<A1> AList { get; set; }
        }
 //例1:簡(jiǎn)單用法
var list3= db.Queryable<A1>().Includes(x => x.BList).ToList(); 
 
 //例2:支持子對(duì)象排序和過(guò)濾
var list3= db.Queryable<A1>().Includes(x => x.BList.Where(z=>z.Id>0).ToList()).ToList(); 
 
 //例3:支持主表過(guò)濾  Any和Count
var list3= db.Queryable<A1>().Includes(x => x.BList)
                             .Where(x=>x.BList .Any(z=>z.Id ==1)).ToList();

var list=db.Queryable<Test>()
               .Includes(x => x.Provinces,x=>x.Citys ,x=>x.Street)//有時(shí)候沒(méi)提示 直接寫(xiě)
               .Includes(x => x.ClassInfo)// 一級(jí)查詢(xún)
               .ToList();

var list = new List<Tree1>();
 
  db.Queryable<Tree1>()
      .Includes(it => it.Child)
      .ForEach(it => list.Add(it), 300); //每次查詢(xún)300條　

var list = db.Queryable<StudentA>().ToList();
db.ThenMapper(list, stu =>
{
  //如果加Where不能帶有stu參數(shù)，stu參數(shù)寫(xiě)到 SetContext
  stu.SchoolA=db.Queryable<SchoolA>().SetContext(scl=>scl.SchoolId,()=>stu.SchoolId,stu).FirstOrDefault();
});
// SetContext不會(huì)生成循環(huán)操作，高性能  和直接Where性能是不一樣的

var treeRoot=db.Queryable<Tree>().Where(it => it.Id == 1).ToList();
//第一層
db.ThenMapper(treeRoot, item =>
{
    item.Child = db.Queryable<Tree>().SetContext(x => x.ParentId, () => item.Id, item).ToList();
});
//第二層
db.ThenMapper(treeRoot.SelectMany(it=>it.Child), it =>
{
    it.Child = db.Queryable<Tree>().SetContext(x => x.ParentId, () => it.Id, it).ToList();
});
//第三層
db.ThenMapper(treeRoot.SelectMany(it => it.Child).SelectMany(it=>it.Child), it =>
{
    it.Child = db.Queryable<Tree>().SetContext(x => x.ParentId, () => it.Id, it).ToList();
});
//這兒只是用樹(shù)型結(jié)構(gòu)來(lái)證明可以實(shí)現(xiàn)無(wú)限級(jí)別導(dǎo)航查詢(xún) ,實(shí)際開(kāi)發(fā)中樹(shù)型結(jié)構(gòu)用ToTree實(shí)現(xiàn)
public class Tree
{
[SqlSugar.SugarColumn(IsPrimaryKey =true)]
public int Id { get; set; }
public string Name { get; set; }
public int ParentId { get; set; }
[SqlSugar.SugarColumn(IsIgnore = true)]
public Tree Parent { get; set; }
[SqlSugar.SugarColumn(IsIgnore = true)]
public List<Tree> Child { get; set; }
}
// SetContext不會(huì)生成循環(huán)操作，高性能  和直接Where性能是不一樣的

{
"Queryable":"order",
 Select:[ [{SqlFunc_AggregateMin:["id"]},"id"], [{SqlFunc_GetDate:[]},"Date"] ]
}