static void Main() { // Database accessor. This opens the database automatically var school = new SchoolEntities(); // This accesses the ClassMaster table foreach (var classMaster in school.ClassMasters) { Console.WriteLine("ClassId: {0}\nClassName: {1}\nClassDescription: {2}\nClassPrice: {3}\n", classMaster.ClassId, classMaster.ClassName, classMaster.ClassDescription, classMaster.ClassPrice); } Console.Write("Done."); Console.WriteLine(); Console.WriteLine(); Console.WriteLine(); // Exercise foreach (var user in school.Users) { Console.WriteLine("{0}", user.UserName); // Display classes for the current student foreach (var classMaster in user.ClassMasters) { Console.WriteLine("\tClassId: {0} ClassName: {1}", classMaster.ClassId, classMaster.ClassName); } Console.WriteLine(); } Console.Write("Done."); Console.ReadLine(); }
static void Main() { // Database accessor. This opens the database automatically var school = new SchoolEntities(); // This accesses the ClassMaster table foreach (var classMaster in school.ClassMasters) { Console.WriteLine("ClassId: {0}\nClassName: {1}\nClassDescription: {2}\nClassPrice: {3}\n", classMaster.ClassId, classMaster.ClassName, classMaster.ClassDescription, classMaster.ClassPrice); } foreach (var user in school.Users) { Console.WriteLine(user.UserName); foreach (var classMaster in user.ClassMasters) { Console.WriteLine("ClassId: {0} Name: {1}", classMaster.ClassId, classMaster.ClassName); } Console.WriteLine("--"); var classIds = school.RetrieveClassesForStudent(user.UserId).ToArray(); foreach (var item in classIds) { var classMaster = school.ClassMasters.FirstOrDefault(t => t.ClassId == item.ClassId); Console.WriteLine("ClassId: {0} Name: {1}", classMaster.ClassId, classMaster.ClassName); } } Console.Write("Done."); Console.ReadLine(); }
static void Main() { // Database accessor. This opens the database automatically var school = new SchoolEntities(); // This accesses the ClassMaster table foreach (var classMaster in school.ClassMasters) { Console.WriteLine("ClassId: {0}\nClassName: {1}\nClassDescription: {2}\nClassPrice: {3}\n", classMaster.ClassId, classMaster.ClassName, classMaster.ClassDescription, classMaster.ClassPrice); } Console.Write("Done."); Console.ReadLine(); }
static void Main() { // Database accessor. This opens the database automatically var school = new SchoolEntities(); var results = school.RetrieveClassesForStudent(1); foreach (var result in results) { var userName = school.Users.First(t => t.UserId == result.UserId).UserName; var className = school.ClassMasters.First(t => t.ClassId == result.Classid).ClassName; Console.WriteLine("User: {0}-{1} Class: {2}-{3}", result.UserId, userName, result.Classid, className); } Console.WriteLine("Classes ======================"); // This accesses the ClassMaster table foreach (var classMaster in school.ClassMasters) { Console.WriteLine("ClassId: {0}\nClassName: {1}\nClassDescription: {2}\nClassPrice: {3}\n", classMaster.ClassId, classMaster.ClassName, classMaster.ClassDescription, classMaster.ClassPrice); } Console.WriteLine("Users ======================"); foreach (var user in school.Users) { Console.WriteLine(user.UserName); foreach (var classMaster in user.ClassMasters) { Console.WriteLine("ClassId: {0} ClassName: {1}", classMaster.ClassId, classMaster.ClassName); } } Console.Write("Done."); Console.ReadLine(); }