我在数据库中有两个没有定义关联的表。
public class Person
{
public int PersonID { get; set; }
public string Name { get; set; }
}
public class Car
{
public int CarID { get; set; }
public string Model { get; set; }
public int PersonID { get; set; }
}
我创建了以下PersonViewModel:
public class PersonViewModel
{
public int PersonID { get; set; }
public string Name { get; set; }
public virtual ICollection<Car> Cars { get; set; }
}
我想做以下事情,但显然是不正确的。非常感谢您的帮助。谢谢。
public PersonViewModel GetPerson(int personID)
{
var query = from p in db.Car
join c in db.Car on p.PersonID equals c.PersonID
where p.PersonID == personID
select new PersonViewModel()
{
PersonID = p.PersonID,
Name = p.Name
Cars = new List<Car>()
{
CarID = c.CarID,
Model = c.Model,
PersonID = p.PersonID
}
};
var person = query.FirstOrDefault();
return person;
}