示例#1
0
 static void Main(string[] args)
 {
     using (DBDataContext db = new DBDataContext())
     {
         try
         {
             //获取要删除的数据
             Test data = db.Test.SingleOrDefault(x => x.Name.Equals("张三1"));
             //删除数据
             db.Test.DeleteOnSubmit(data);
             //提交删除
             db.SubmitChanges();
             Console.WriteLine("数据删除成功!");
         }
         catch
         {
             Console.WriteLine("数据删除失败!");
         }
     }
 }
示例#2
0
 static void Main(string[] args)
 {
     using (DBDataContext db = new DBDataContext())
     {
         try
         {
             //查询张三的信息到data
             Test data = db.Test.First(x => x.Name.Equals("张三"));
             //修改张三的信息
             data.Name = "张三1";
             data.Sex  = "女";
             //提交更改
             db.SubmitChanges();
             Console.WriteLine("数据修改成功!");
         }
         catch
         {
             Console.WriteLine("数据修改失败!");
         }
     }
 }
示例#3
0
 /// <summary>
 /// 添加数据
 /// </summary>
 /// <param name="args"></param>
 static void Main(string[] args)
 {
     using (DBDataContext db = new DBDataContext())
     {
         try
         {
             //实例化数据
             Test data = new Test();
             data.Name = "测试";
             data.Sex  = "男";
             data.Time = DateTime.Now;
             //添加数据
             db.Test.InsertOnSubmit(data);
             //提交更改
             db.SubmitChanges();
             Console.WriteLine("数据添加成功!");
         }
         catch
         {
             Console.WriteLine("数据添加失败!");
         }
     }
 }