LinQToSQL

  /// <summary>
        /// 查询
        /// </summary>
        /// <param name="name"></param>
        public static void LinQToSQL()
        {
            var db = new DataClasses1DataContext();
            var results = from c in db.Users
                          where c.LoginId == "xiaoxin"
                          where c.LoginPwd=="123"
                          select c;
            foreach (var item in results)
            {
                Console.WriteLine(item.Name+","+item.Mail);
            }
            Console.ReadKey();
        }
        /// <summary>
        /// 数据增加
        /// </summary>
        public static void LinQTOSQL2()
        {
            var db = new DataClasses1DataContext();
            int count = db.Users.Where(c => c.LoginId == "xx").Count();
            var user = new Users()
            {
                LoginId="xx",
                LoginPwd="123",
                Mail="xxxx",
                Name="xx",
                Phone="33333333333",
                UserRoleId=2,
                UserStateId=1,
                Address="zxc",
                Gender=1
            };
            db.Users.InsertOnSubmit(user);
            db.SubmitChanges();
            int count2 = db.Users.Where(c => c.LoginId == "xx").Count();
            if (count<count2)
            {
                Console.WriteLine("see");
            }
           
        }
        /// <summary>
        /// 多表连接查询
        /// </summary>
        public static void LinQTOSQL4()
        {

            var db = new DataClasses1DataContext();
            var resultes = from c in db.Users
                           from x in db.UserStates
                           where c.UserStateId == x.Id
                           where c.LoginId == "xiaoxin"
                           select new {c.LoginId,x.Name };
            foreach (var item in resultes)
            {
                Console.WriteLine(item.LoginId+"~~~~~~~~~~~~"+item.Name);
            }
            Console.ReadKey();
        }
        /// <summary>
        /// 模糊查询
        /// </summary>
        public static void LinQTOSQL5()
        {
            var db = new DataClasses1DataContext();
            var resltes = from c in db.Users
                          where c.LoginId.StartsWith("x")
                          select c;
            foreach (var item in resltes)
            {
                Console.WriteLine(item.LoginId+"--------------"+item.Name);
            }
            Console.ReadKey();
        }
        /// <summary>
        /// 删除
        /// </summary>
        public static void LinQTOSQL6()
        {
            var db = new DataClasses1DataContext();
            var reslues = (from c in db.Users
                           where c.LoginId == "xx"
                           select c).FirstOrDefault();
            db.Users.DeleteOnSubmit(reslues);
            db.SubmitChanges();
            Console.WriteLine("cg");
            Console.ReadKey();
        }
        /// <summary>
        /// 修改
        /// </summary>
        public static void LinQToSQL7()
        {
            var db = new DataClasses1DataContext();
            var reslues = (from c in db.Users
                           where c.LoginId == "xx"
                           select c).SingleOrDefault();
            reslues.Name = "xxxx";
            db.SubmitChanges();
            Console.WriteLine("ok");
            Console.ReadKey();
                      
        }