求一对一的查询语句

[wzllin111]

    public class Student
    {
        [Key]
        public int Id { get; set; }
        public string Name { get; set; }
        public StudentAddress studentAddress { get; set; }
    }

   public partial class StudentAddress
    {
        [Key, ForeignKey("Student")]
        public int Studentid { get; set; }
        public string City { get; set; }
        public string Zipcode { get; set; }
        public string Country { get; set; }
        public  Student Student { get; set; }
    }

要求查询出所有Student的信息

[泉低调前行]

var studentinfo = from x in student join y in studentaddress on x.id equals y.studentid where x.id == xxx Select new ViewModel(可以把你显示字段放进去){ .里面写出你想显示的字段 };

[wzllin111]

引用 1 楼 贵阳老马马善福专业维修游泳池堵漏防水工程 的回复:

var studentinfo = (from x in student join y in studentaddress on x.id equals y.studentid where x.id == xxx).select(z => new { student = z.x, studentaddress = z.y }).first()

报错了

[正怒月神]

不用一对一查询。 直接 var stu=Student.First(x=>id==1)； 如果要用到 第一个address地址。 那么就是 stu.Address.First();

[threenewbee]

var studentinfo = (from x in student
join y in studentaddress on x.id equals y.studentid
where x.id == xxx).select(z => new { student = z.x, studentaddress = z.y }).first()