ORM支持导航属性吗 返回
[SugarTable("STudent")]
public class Student
{
[SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnName = "ID")]
public int Id { get; set; }
public int? SchoolId { get; set; }
public string Name { get; set; }
public DateTime? CreateTime { get; set; }
[SugarColumn(IsIgnore=true)]
public int TestId { get; set; }
public School School { get; set; }
}
var db = GetInstance();
var q = db
.Queryable<Student>()
.Where(a => a.Name == "1");
q = q.Where(b => b.Name == "2");
q = q.Where(c => c.School.Name == "3");
var r = q.ToList();
然后就报错了,如图:

如果支持导航属性的查询(EF是支持这种写法的),麻烦给个文档示例,非常感谢。
热忱回答(2)
-
fate stay night VIP0
2017/11/1这么用的 http://www.donet5.com/Doc/8/1143
0 回复 -
绝情草 VIP0
2017/11/13这种用法,貌似效率好低。
EF的Include() 后是一次性查出来的
0 回复