Linq to SQL之增删查改

            YPTHDataContext ypth = new YPTHDataContext();
            var query = from val in ypth.T_User select val;
            foreach (var item in query)
            {
                Console.WriteLine(item.ID + "----" + item.Name + "----" + item.Pwd);
            }
            Console.WriteLine("where查询");
            query = query.Where(item => item.Name == "jack");
            foreach (var item in query)
            {
                Console.WriteLine(item.ID + "----" + item.Name + "----" + item.Pwd);
            }
            Console.WriteLine("插入数据");
            T_User t_user = new T_User();
            
            t_user.Name = "Gandoulf";
            t_user.Pwd = "123456";
            ypth.T_User.InsertOnSubmit(t_user);
            ypth.SubmitChanges();
            Console.WriteLine("新增之后");
            query = from val in ypth.T_User select val;
            foreach (var item in query)
            {
                Console.WriteLine(item.ID + "----" + item.Name + "----" + item.Pwd);
            }
            Console.WriteLine("删除ID=1018");
            t_user = ypth.T_User.SingleOrDefault(item => item.ID == 1018);
            ypth.T_User.DeleteOnSubmit(t_user);
            Console.WriteLine("修改ID=1016");
            t_user = ypth.T_User.SingleOrDefault(item => item.ID == 1016);
            t_user.Name = "Peter JackSon";
            ypth.SubmitChanges();