Get value from db in list

Question

I have following code. It is giving me list of events. In that I want get patient name.

I have patient Id, but I am confused how can I get patient name using that id.

events = db.PTSessions.Where(x => x.OfficeIdFk == user.OfficeIdFk || x.PTIdFk == user.PTId).Where((a => a.AppointmentDate > start &&
                (a.AppointmentTimeTo < end))).Select(m => new EventViewModel
                {
                    id = m.SessionId,
                    title = m.AppointmentReason,
                    start = m.AppointmentTimeFrom,
                    end = m.AppointmentTimeTo,
                    allDay = false,
                    patientid = m.PatientIdFk,
                    appointmentstatus = m.AppointmentStatus,
                    patientname = db.Patients.Where(p => p.PatientId == m.PatientIdFk).Select(p => p.PatientName).ToString()
                }).ToList();

in above code I can't get patientname and getting error also.

Thanks

@Jackdaw I am getting this error : The specified type member 'PatientName' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported. — Nic
– Nic, Commented Sep 16, 2021 at 12:08
@Nic Do you have proper Relation between PTSessions and Patients entity? if yes then inside PTSession entity you will find Patient entity (x.Patient like this), that will solve your problem — Smits
– Smits, Commented Sep 16, 2021 at 12:29

Serge · Accepted Answer · 2021-09-16 11:43:55Z

2

try this

patientname = db.Patients.Where(p => p.PatientId == m.PatientIdFk)
.Select(p => p.PatientName).FirstOrDefault()

answered Sep 16, 2021 at 11:43

Serge

44.4k4 gold badges26 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nic Over a year ago

I tried this and getting this error : The specified type member 'PatientName' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.

Serge Over a year ago

@Nic Pls post Patient class too

Collectives™ on Stack Overflow

Get value from db in list

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related