/// <summary>
/// Create a new PatientVisit object.
/// </summary>
/// <param name="visitId">Initial value of the VisitId property.</param>
/// <param name="cost">Initial value of the Cost property.</param>
/// <param name="hospital">Initial value of the Hospital property.</param>
/// <param name="patientId">Initial value of the PatientId property.</param>
public static PatientVisit CreatePatientVisit(global::System.Int32 visitId, global::System.Decimal cost, global::System.String hospital, global::System.Int32 patientId)
{
PatientVisit patientVisit = new PatientVisit();
patientVisit.VisitId = visitId;
patientVisit.Cost = cost;
patientVisit.Hospital = hospital;
patientVisit.PatientId = patientId;
return(patientVisit);
}
static void RunExample()
{
using (var context = new EFRecipesEntities())
{
string hospital = "Oakland General";
var p1 = new Patient {
Name = "Robin Rosen", Age = 41
};
var p2 = new Patient {
Name = "Alex Jones", Age = 39
};
var p3 = new Patient {
Name = "Susan Kirby", Age = 54
};
var v1 = new PatientVisit {
Cost = 98.38M, Hospital = hospital, Patient = p1
};
var v2 = new PatientVisit {
Cost = 1122.98M, Hospital = hospital, Patient = p1
};
var v3 = new PatientVisit {
Cost = 2292.72M, Hospital = hospital, Patient = p2
};
var v4 = new PatientVisit {
Cost = 1145.73M, Hospital = hospital, Patient = p3
};
var v5 = new PatientVisit {
Cost = 2891.07M, Hospital = hospital, Patient = p3
};
context.Patients.AddObject(p1);
context.Patients.AddObject(p2);
context.Patients.AddObject(p3);
context.SaveChanges();
}
using (var context = new EFRecipesEntities())
{
Console.WriteLine("Query using eSql...");
var esql = @"Select value ps from EFRecipesEntities.Patients as p join EFRecipesModel.GetVisitSummary() as ps on p.Name = ps.Name where p.Age > 40";
var patients = context.CreateQuery <VisitSummary>(esql);
foreach (var patient in patients)
{
Console.WriteLine("{0}, Visits: {1}, Total Bill: {2}",
patient.Name, patient.TotalVisits.ToString(), patient.TotalCost.ToString("C"));
}
}
using (var context = new EFRecipesEntities())
{
Console.WriteLine();
Console.WriteLine("Query using LINQ...");
var patients = from p in context.Patients
join ps in context.GetVisitSummary() on p.Name equals ps.Name
where p.Age >= 40
select ps;
foreach (var patient in patients)
{
Console.WriteLine("{0}, Visits: {1}, Total Bill: {2}",
patient.Name, patient.TotalVisits.ToString(), patient.TotalCost.ToString("C"));
}
}
Console.WriteLine("Press <enter> to continue...");
Console.ReadLine();
}
/// <summary>
/// Deprecated Method for adding a new object to the PatientVisits EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToPatientVisits(PatientVisit patientVisit)
{
base.AddObject("PatientVisits", patientVisit);
}
