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的資訊
uj5u.com熱心網友回復：
var studentinfo = (from x in studentjoin y in studentaddress on x.id equals y.studentid
where x.id == xxx).select(z => new { student = z.x, studentaddress = z.y }).first()
uj5u.com熱心網友回復：
報錯了
uj5u.com熱心網友回復：
不用一對一查詢。直接
var stu=Student.First(x=>id==1)；
如果要用到 第一個address地址。
那么就是 stu.Address.First();
uj5u.com熱心網友回復：
var studentinfo = from x in studentjoin y in studentaddress on x.id equals y.studentid
where x.id == xxx Select new ViewModel(可以把你顯示欄位放進去){
.里面寫出你想顯示的欄位
};
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/43106.html
標籤：LINQ