static void Main(string[] args) { HiTechDbContext dbContext = new HiTechDbContext(); //Case1(dbContext); //Case2(dbContext); //Case3(dbContext); //Case4(dbContext); //Case5(dbContext); }
private static void Case3(HiTechDbContext dbContext) { var studentList = dbContext.Students.Where(s => s.Name.Contains("a")).Take(2) .ToList(); foreach (var s in studentList) { Console.WriteLine("{0}, {1}, {2}, {3}", s.Id, s.Name, s.Age, s.City); } }
private static void Case2(HiTechDbContext dbContext) { var students = dbContext.Students.Select(m => new { name = m.Name, age = m.Age, city = m.City }); foreach (var s in students) { Console.WriteLine("Name: {0}, Age: {1}, City: {2}", s.name, s.age, s.city); } }
private static void Case5(HiTechDbContext dbContext) { var studentList = dbContext.Students.Where(s => s.Name.Contains("s")) .Where(s => s.Age > 21) .ToList() .Select(s => new { name = s.Name.Split(' ')[0], age = s.Age }); foreach (var s in studentList) { Console.WriteLine("{0}, {1}", s.name, s.age); } }
private static void Case1(HiTechDbContext dbContext) { Student student = new Student(); student.Id = 101; student.Name = "Akash"; student.Age = 21; student.City = "Ahmedabad"; Student student2 = new Student(); student2.Id = 102; student2.Name = "Parth"; student2.Age = 22; student2.City = "Ahmedabad"; Student student3 = new Student(); student3.Id = 103; student3.Name = "Brijesh"; student3.Age = 22; student3.City = "Mumbai"; Student student4 = new Student(); student4.Id = 104; student4.Name = "Devang"; student4.Age = 22; student4.City = "Ahmedabad"; dbContext.Students.Add(student); dbContext.Students.Add(student2); dbContext.Students.Add(student3); dbContext.Students.Add(student4); dbContext.SaveChanges(); }