DataClasses1DataContext dc = new DataClasses1DataContext();

       

      //1.查询

      IQueryable<tb_GuestInfo> query = from p in dc.tb_GuestInfo

                       where p.Name != "XXX"

                       select p;

 

      foreach (var g in query)

      {

        Console.WriteLine("{0} {1} {2} {3}",g.Id,g.Name,g.Age ,g.Tel );

      }

 

      Console.WriteLine("-----------------");

      Console.ReadKey(false);

      //2.增加一条记录

      tb_GuestInfo gInfo = new tb_GuestInfo() { Id = 9, Name = "M&M", Age = 40, Tel = "135****5555" };

      dc.tb_GuestInfo.InsertOnSubmit(gInfo);

      dc.SubmitChanges();

 

      foreach (var g in query)

      {

        Console.WriteLine("{0} {1} {2} {3}",g.Id , g.Name, g.Age, g.Tel);

      }

 

      Console.WriteLine("-----------------");

      Console.ReadKey(false);

 

      //3.删除

      var query_itemToDelete = from g in dc.tb_GuestInfo

                   where g.Name == "M&M"

                   select g;

      foreach (var g in query_itemToDelete)

      {

        dc.tb_GuestInfo.DeleteOnSubmit(g);

      }

      dc.SubmitChanges();