我有這個(gè) linq to SQL，我只想用連接藥物返回一種疾病。但這所做的是返回所有疾病并且僅填充滿足 where 條件的藥物。我是否需要先選擇藥物，然后選擇疾病才能發(fā)揮作用？ public List<Model.Disease> GetDiseaseById(Guid DiseaseId) { var Disease = (from Diseases in db.Diseases join dr in db.DrugDiseases on equals d.DrugId on dr.DrugId join rdDiseases on rdDiseases.Diseases equals rd.DiseaseId on dr.DiseaseId where (aDrug.DiseaseId == DiseaseId) select new Model.Disease { DiseaseId = rdDiseases.DiseaseId, DiseaseName = rdDiseases.DiseaseName, drug = (from d in db.Drug join dr1 in db.DrugDiseases on equals d.DrugId on dr1.DrugId join rd1Diseases on rdDiseases.Diseases equals rd.DiseaseId on dr1.DiseaseId where (Diseases.DiseaseId == d.DiseaseId && d.DiseaseId == DiseaseId) select new drug { DrugId = d.drug, DrugName = d.drugName}).OrderBy(m => m.DrugName).ToList(), }).OrderBy(d => d.DiseaseName).ToList().FirstOrDefault(); return Disease; }
1 回答
GCT1015
TA貢獻(xiàn)1827條經(jīng)驗(yàn) 獲得超4個(gè)贊
既然您只尋找一種疾病，為什么要返回一個(gè)列表呢？下面的代碼應(yīng)該可以工作：
public Model.Disease GetDiseaseById(Guid DiseaseId)
{
? ?return (from Disease in db.Diseases
? ? ? ? ? ? ? ?where Disease.DiseaseId == DiseaseId
? ? ? ? ? ? ? ?orderby Disease.DiseaseName
? ? ? ? ? ? ? ?join d in db.Drug on Disease.DiseaseId equals d.DiseasesId
? ? ? ? ? ? ? ?select new Model.Disease
? ? ? ? ? ? ? ?{
? ? ? ? ? ? ? ? ? ?DiseaseId = Disease.DiseaseId
? ? ? ? ? ? ? ? ? ?DiseaseName = Disease.DiseaseName
? ? ? ? ? ? ? ? ? ?drug = new { DrugId = d.DrugId, DrugName = d.DrugName }
? ? ? ? ? ? ? ?}).FirstOrDefault();
}
- 1 回答
- 0 關(guān)注
- 124 瀏覽
添加回答
舉報(bào)
0/150
提交
取消