使用 LINQ 添加子值始终为 1

发布于 2024-11-25 03:59:15 字数 1078 浏览 4 评论 0原文

我有表

PatientEligilit 和 患者资格医生专业 和 医生专科

患者资格 具有外键 PatientsEligibilitiesDoctorsSpecialtyID 来自 患者资格医生专业 表

和

PatientsEligbilitiesDoctorsSpecialty 具有外键 DoctorsSpecialtyID 来自 医生专业 表

然后使用VB.NET LINQ：我正在尝试添加子项目（PatientsEligibilitiesDoctorsSpecialty）给它的父级（PatientEligilit）

，然后我提交更改，

例如：

PatientEligibilityObject.PatientsEligibilitiesDoctorsSpecialties.Add(New PatientsEligibilitiesDoctorsSpecialty With {.DoctorSpecialtyID = si.ID, .RegDate = Date.Now})                                                                            PatientEligibilityObject.PatientsEligibilitiesDoctorsSpecialties.Add(PEDS)
HMSData.SubmitChanges()

它运行良好，并以正确的日期将记录保存在数据库中

但

DoctorSpecialtyID

始终保存为值1

原文

I have the Tables

PatientEligibilit
and
PatientsEligibilitiesDoctorsSpecialties
and
DoctorsSpecialties

PatientEligibilit
has foreign key PatientsEligibilitiesDoctorsSpecialtyID from
PatientsEligibilitiesDoctorsSpecialties
table

and

PatientsEligibilitiesDoctorsSpecialty
has foreign key DoctorsSpecialtyID from
DoctorsSpecialties
table

THEN USING VB.NET LINQ: i'm tring to add child item ( PatientsEligibilitiesDoctorsSpecialty)
to it's parent (PatientEligibilit)

then I submit Changes

like :

PatientEligibilityObject.PatientsEligibilitiesDoctorsSpecialties.Add(New PatientsEligibilitiesDoctorsSpecialty With {.DoctorSpecialtyID = si.ID, .RegDate = Date.Now})                                                                            PatientEligibilityObject.PatientsEligibilitiesDoctorsSpecialties.Add(PEDS)
HMSData.SubmitChanges()

it's worked fine and save record in Database with correct date

BUT