首先在EF 6设计中检索关联表的值

我们首先在设计实体框架6中开发数据库，我们有医生和诊所表之间的多对多关系。在数据库中生成的clinicdoctor表具有clinicid和doctorid。我们想从clinicdoctor表

中检索值

public partial class Doctor
    {
        public Doctor()
        {
            this.Patients = new HashSet<Patient>();
            this.Presriptions = new HashSet<Prescription>();
            this.Clinics = new HashSet<Clinic>();
        }
    public int DoctorId { get; set; }
    public string DoctorName { get; set; }
    public string Specialist { get; set; }
    public virtual ICollection<Clinic> Clinics { get; set; }
} 

我们想使用通用Repository Get(doctorId)方法检索与该医生相关的所有诊所

var clinics = unitOfWork.ClinincRepository.Get();

var clinics = unitOfWork.ClinicDoctorRepository.Include("Clinics").Where(m => m.DoctorId == doctorId).Get();