static void Main(string[] args) { using (var db = new ContosoUniversityEntities()) { // 印出sql指令 db.Database.Log = (sql) => { Console.WriteLine(sql); }; //GetCourse_Git(db); //GetDepartment(db); //AddCourse(db); //UpdateCourse(db); //DeleteCourse(db); var one = db.Course.Find(6); //// 改狀態 //db.Entry(one).State = System.Data.Entity.EntityState.Modified; //// 依狀態,所以執行update sql //db.SaveChanges(); //var c = new Course() { CourseID = 7 }; //// 改狀態 //db.Entry(c).State = System.Data.Entity.EntityState.Deleted; //db.Course.Remove(c); //// 依狀態,所以執行delete sql //db.SaveChanges(); // 這邊是看狀態的變化 //Console.WriteLine(db.Entry(one).State); //one.MyCredits += 1; //Console.WriteLine(db.Entry(one).State); ////db.Entry(one).State = System.Data.Entity.EntityState.Deleted; //db.SaveChanges(); //Console.WriteLine(db.Entry(one).State); var data = db.GetCourse("%Git%"); foreach (var item in data) { Console.WriteLine(item.Title); } Console.ReadLine(); // 有這一行,console才不會馬上就被關掉 } }
static void Main(string[] args) { using (var db = new ContosoUniversityEntities()) { db.Database.Log = (msg) => { Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine(msg); Console.ResetColor(); }; //SelectCourseByGitOrderByCredits(db); //SelectCourseWithRelation(db); //Console.WriteLine("--"); //SelectDepartmentWithRelation(db); //PracticeCRUD(db); //PracticeLazyLoading(db); //ManyToManyAddWithExceptionHandling(db); //AsNoTracking(db); //DemoAttachAndEntityState(db); //var dept = new Department() //{ // DepartmentID = 17, // Name = "酷奇資訊2", // Budget = 18000, // StartDate = new DateTime(2019, 6, 1, 0, 0, 0), // UpdatedOn = DateTime.Now //}; //DemoEntityEntryRemove(db); //var dept = db.Department.Add(new Department() //{ // Name = "酷奇資訊3", // Budget = 18000, // StartDate = new DateTime(2019, 6, 1, 0, 0, 0) //}); //db.SaveChanges(); //var dept = db.Department.Find(1); //dept.Budget += 1; //Console.ReadKey(); //db.SaveChanges(); var data = db.GetCourse("Git"); foreach (var item in data) { Console.WriteLine(item.Title); } } }