利用LINQ to SQL 增删改查本地数据库

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了利用LINQ to SQL 增删改查本地数据库，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2015字，纯文字阅读大概需要3分钟。

内容图文

1. LINQ to SQL查询数据库

   //查询数据库
   using (DbAppDataContext context = new DbAppDataContext())
   {
          context.Log = Console.Out;
          var query = from p in context.PeopleInfoTables
                      let length = p.Names.Length
                      orderby length
                      select new { Name = p.Names, Length = length };
          foreach (var entry in query)
          {
                Console.WriteLine("{0}:{1}", entry.Name, entry.Length);
          }
   }
   
   输出结果
   

2. LINQ to SQL增加数据库信息

   //往数据库增加信息
   using (DbAppDataContext context = new DbAppDataContext())
   {
        context.Log = Console.Out;
        context.PeopleInfoTables.InsertOnSubmit(new PeopleInfoTable
        {
            Names = "Qinan",
            Addresses = "Shaoxing",
            Ages = 24,
            ID = "1231231",
            Nations = "China",
            Phones = "18868875132"
         });
         context.SubmitChanges();
         var query = from p in context.PeopleInfoTables
             select new { Name = p.Names, Address = p.Addresses };
         foreach (var entry in query)
         {
             Console.WriteLine("{0}:{1}", entry.Name, entry.Address);
         }
   }
   
   输出结果
   

3. LINQ to SQL删除数据库信息

   //删除数据库某条信息
   using (DbAppDataContext context = new DbAppDataContext())
   {
         context.Log = Console.Out;
         var people = context.PeopleInfoTables.SingleOrDefault(p => p.Names == "Qinan");
         if (people != null)
         {
             context.PeopleInfoTables.DeleteOnSubmit(people);
             context.SubmitChanges();
         }
         var query = from p in context.PeopleInfoTables
              select new { Name = p.Names, Address = p.Addresses };
         foreach (var entry in query)
         {
              Console.WriteLine("{0}:{1}", entry.Name, entry.Address);
         }
   }
   
   输出结果

4. LINQ to SQL编辑数据库

   //编辑数据库中的信息
   using (DbAppDataContext context = new DbAppDataContext())
   {
       context.Log = Console.Out;
       var people = context.PeopleInfoTables.SingleOrDefault(p => p.Names == "Yuan");
       if (people != null)
       {
           people.Ages = 50;
           people.Addresses = "tanggu";
           context.SubmitChanges();
       }
       var query = from p in context.PeopleInfoTables
            select new {Name = p.Names, Age = p.Ages, Address = p.Addresses};
       foreach (var entry in query)
       {
            Console.WriteLine("{0}:{1},{2}", entry.Name, entry.Age, entry.Address);
       }
   }
   
   输出结果
   
   

    

利用LINQ to SQL 增删改查本地数据库

标签：

本文系统来源：http://www.cnblogs.com/yuanxiaoyuan/p/5978021.html

内容总结

以上是互联网集市为您收集整理的利用LINQ to SQL 增删改查本地数据库全部内容，希望文章能够帮你解决利用LINQ to SQL 增删改查本地数据库所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端