//public GetAddressesOfStudentsResponse GetAddressesOfStudents()
//{
// List<StudentAddresses> addresses = null;
// using (var ctx = new SchoolDbEntities())
// {
// addresses = ctx.Students.Include("StudentAddress").Select(x => new StudentAddresses()
// {
// Id = x.StudentId,
// FirstName = x.FirstName,
// LastName = x.LastName,
// Address = x.StudentAddress == null ? null : new AddressModel()
// {
// StudentId = x.StudentId,
// Address1 = x.StudentAddress.Address1,
// Address2 = x.StudentAddress.Address2,
// City = x.StudentAddress.City,
// State = x.StudentAddress.State
// }
// }).ToList<StudentAddresses>();
// }
// return new GetAddressesOfStudentsResponse
// {
// StudentAddresses = addresses
// };
//}
public GetAddressesOfStudentsResponse GetAddressesOfStudents()
{
List <StudentAddresses> addresses = null;
using (var ctx = new SchoolDbEntities())
{
addresses = ctx.MapStudentAddresses();
}
return(new GetAddressesOfStudentsResponse
{
StudentAddresses = addresses
});
}
internal static List <StudentAddresses> MapStudentAddresses(this SchoolDbEntities ctx)
{
return(ctx.Students.Include("StudentAddress").Select(x => new StudentAddresses()
{
Id = x.StudentId,
FirstName = x.FirstName,
LastName = x.LastName,
Address = x.StudentAddress == null ? null : new AddressModel()
{
StudentId = x.StudentId,
Address1 = x.StudentAddress.Address1,
Address2 = x.StudentAddress.Address2,
City = x.StudentAddress.City,
State = x.StudentAddress.State
}
}).ToList <StudentAddresses>());
}
public GetAllStudentResponse GetAllStudents()
{
List <StudentModel> students = null;
using (var ctx = new SchoolDbEntities())
{
students = ctx.Students
.Select(s => new StudentModel()
{
Id = s.StudentId,
FirstName = s.FirstName,
LastName = s.LastName
}).ToList <StudentModel>();
}
return(new GetAllStudentResponse
{
Students = students
});
}
static DatabaseAccessor()
{
entities = new SchoolDbEntities();
entities.Database.Connection.Open();
}
