public Patient GetPatientDetails(int patientId)
{
MedicalDBEntities entities = new MedicalDBEntities();
var patient = entities.Patients.Find(1);
_logger.LogInformation("<wcf service> get details of patient ID {0}", patientId);
return(patient);
}
public string GetPatients6()
{
MedicalDBEntities entities = new MedicalDBEntities();
var patients = from a in entities.Patients where a.PatientId == 1 select a;
_logger.LogInformation("query for patient by ID: {0}", patients);
return("got patient by SQL: " + patients);
}
public List <Patient> GetPatients4()
{
MedicalDBEntities entities = new MedicalDBEntities();
var patients = entities.Patients.Where(p => p.PatientId == 1);
_logger.LogInformation("query for patient by ID: {0}", patients.Count());
return(patients.ToList());
}
public string GetPatients5()
{
MedicalDBEntities entities = new MedicalDBEntities();
var patients = entities.Patients.Any(p => p.PatientId == 1);
_logger.LogInformation("query for patient by ID: {0}", patients);
return("got patient: " + patients);
}
public List <Patient> GetPatients3()
{
MedicalDBEntities entities = new MedicalDBEntities();
var patients = entities.Patients.Select(p => p);
foreach (var p in patients)
{
_logger.LogInformation("retrieve patient <getpatients3>: {0} {1}", p.FirstName, p.LastName);
}
return(patients.ToList());
}
