Select, Insert, Update, Delete문

 

// 1. select 쿼리
                //1) DbSet<Entities.User> selectList = db.Users; 
                //2) List<User> selectList = db.Users.ToList(); 
                //3) IEnumerable<User> selectList = db.Users.AsEnumerable(); 

                //List<User> selectList = db.Users.ToList();

                //foreach (var item in selectList)
                //{
                //    Console.WriteLine(item.UserName);
                //}


                // 2. Insert 쿼리
                // db.Users.Add(User); 선언한 dbcontext에서 Users라는 테이블에 추가한다. User클래스를 추가한다. 
                // db.SaveChanges();  commit

                //var user = new User();
                //user.UserID = 3;
                //user.UserName = "임결동";
                //user.Birth = "800908";

                //var user = new User
                //{
                //    UserID = 3,
                //    UserName = "임결동",
                //    Birth = "800908"
                //};

                //db.Users.Add(new User
                //{
                //    UserID = 3,
                //    UserName = "임결동",
                //    Birth = "800908"
                //});

                //db.SaveChanges(); 
                //Console.WriteLine("Insert completed"); 

                // 3. update문
                // var user = new User { UserId = 1, UserName = " 장길동" }; 
                // db.Entry(user).State = EntityState.Modified; db.entry에 user에 넣고 상태가 수정 (modified)하겠다
                // db.SaveChanges(); 

                // 4. Delete문
                //var user = new User { UserId = 1 };
                //db.Users.Remove(user);
                //db.SaveChanges();