static void Run1() { var _context = new eddbContext(); //_context.Students.ToList() // .ForEach(s => Console.WriteLine($"{s.Firstname} {s.Lastname}")); //var majors = from m in _context.Majors // where m.MinSat > 1000 // orderby m.Description // select m; //foreach(var m in majors) { // Console.WriteLine($"{m.Description} | {m.MinSat}"); //} var studentmajor = (from s in _context.Students join m in _context.Majors on s.MajorId equals m.Id select new { Name = s.Firstname + " " + s.Lastname, Major = m.Description }).ToList(); studentmajor.ForEach(s => Console.WriteLine($"{s.Name} | {s.Major}")); }
static void Run1() { // this is Method Syntax var _context = new eddbContext(); _context.Students.ToList() .ForEach(s => Console.WriteLine($"{s.Firstname} {s.Lastname}")); // this is Qurey Syntax var majors = from m in _context.Majors where m.MinSat > 1000 orderby m.Description select m; foreach (var m in majors) { Console.WriteLine($"{m.Description} | {m.MinSat}"); } // join Students & Majors. print Name and Major var allStudents = (from s in _context.Students join m in _context.Majors.DefaultIfEmpty() on s.MajorId equals m.Id into grp from mm in grp.DefaultIfEmpty() select new { Name = s.Firstname + " " + s.Lastname, Major = mm == null ? "undeclared" : mm.Description }).ToList(); // a lot of stuff happening here, have becca or her mom better explain allStudents.ForEach(s => Console.WriteLine($"{s.Name} - {s.Major}")); }
static void Run1() { var _context = new eddbContext(); // setting an instance of the database var students = _context.Students.ToList(); // setting the student variable foreach (var s in students) { Console.WriteLine($"{s.Firstname} {s.Lastname} "); } Console.WriteLine($" "); var _context2 = new eddbContext(); // easier way to do above foreach (var s in _context2.Students.ToList()) // plugging the context straight into the collection { Console.WriteLine($"{s.Firstname} {s.Lastname} "); } Console.WriteLine($" "); var _context3 = new eddbContext(); // easiest way to do above _context3.Students.ToList() .ForEach(s => Console.WriteLine($"{s.Firstname} {s.Lastname} ")); Console.WriteLine($""); var majors = from m in _context.Majors // show all the majors that require a minSAT over 1000 where m.MinSat > 1000 orderby m.Description select m; foreach (var m in majors) { Console.WriteLine($"{m.Description} || {m.MinSat}"); } Console.WriteLine($""); // show all student with their majors var allstudents = (from s in _context.Students // inner join example join m in _context.Majors //.DefaultIfEmpty() on s.MajorId equals m.Id orderby s.Lastname select new { Name = s.Firstname + " " + s.Lastname, Major = s.MajorId == null ? "Undeclared" : m.Description }).ToList(); foreach (var s in allstudents) { Console.WriteLine($"{s.Name} | {s.Major}"); } Console.WriteLine($" "); var allstudents2 = (from s in _context.Students // outter join example of above join m in _context.Majors // getting all students including ones without a major on s.MajorId equals m.Id into grp // grp is a short term holding collection to run the code from mm in grp.DefaultIfEmpty() // "mm" is the major select new { Name = s.Firstname + " " + s.Lastname, Major = s.MajorId == null ? "Undeclared" : mm.Description // if there is a major that is null it will change it to "Undeclared" }).ToList(); foreach (var s in allstudents2) { Console.WriteLine($"{s.Name} | {s.Major}"); } }
public MajorController() // default constructor { _context = new eddbContext(); }
public StudentsController() { _context = new eddbContext(); // this is to be able to control the data we put in and write it. }
public MajorController() { _context = new eddbContext(); }
public StudentsController() { _context = new eddbContext(); }
public StudentsController() // default constructor { _context = new eddbContext(); }