public IEnumerable <StudentClass> GetStudents() { List <StudentClass> students = new List <Models.StudentClass>(); var selectStudents = from s in db.Students join c in db.tblCountries on s.Country equals c.Id select new { s.StudentID, s.City, s.Class, s.Email, s.EnrollYear, s.Name, CountryName = c.Name, c.Id }; foreach (var item in selectStudents) { StudentClass student = new Models.StudentClass { StudentID = item.StudentID, Name = item.Name, City = item.City, Class = item.Class, Email = item.Email, EnrollYear = item.EnrollYear, AssociatedCountry = new Country { Id = item.Id, Name = item.CountryName } }; students.Add(student); } return(students); }
public ActionResult MyClasses(int StudentId) { ViewData["id"] = StudentId; List <DataProcessor.StudentClass> studentClasses = studentClassProcessor.StudentClasses(sqlConnection, StudentId); //BUT you can also create an MVC data model, which decouples the requierment of a DLL (could switch to a XML or JSON file later!) Models.StudentClass classes; List <Models.StudentClass> myclasses = new List <Models.StudentClass>(); foreach (var row in studentClasses) { classes = new Models.StudentClass(row.ClassID, row.ClassName, row.ClassDate, row.ClassDescription, row.StudentID, row.StudentName, row.StudentEmail); myclasses.Add(classes); } return(View(myclasses)); }