首页 / C# / Linq To Sql 增改删
Linq To Sql 增改删
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Linq To Sql 增改删,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2325字,纯文字阅读大概需要4分钟。
内容图文
![Linq To Sql 增改删](/upload/InfoBanner/zyjiaocheng/486/c5ae424406e345469d91741d00ad976c.jpg)
using System; using System.Data.Linq.Mapping; namespace ConsoleApplication3 { [Table(Name = "test")] public class db_test_info { [Column(IsPrimaryKey = true, IsDbGenerated = true)] public int t_id { get; set; } [Column] public string t_name { get; set; } } }
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SqlClient; using System.Data.Linq; namespace ConsoleApplication3 { class Program { private static string m_conn_str = "server=192.168.1.15;database=goods2;uid=sa;pwd=000"; private static void Test<T>(T t) where T : class { Console.WriteLine(t.ToString()); } public static void New(string name) { using (SqlConnection conn = new SqlConnection(m_conn_str)) { using (DataContext dc = new DataContext(conn)) { Table<db_test_info> db = dc.GetTable<db_test_info>(); db_test_info info = new db_test_info() { t_name = name }; db.InsertOnSubmit(info); dc.SubmitChanges(); } } } public static void Update(string name,string newname) { using (SqlConnection conn = new SqlConnection(m_conn_str)) { using (DataContext dc = new DataContext(conn)) { Table<db_test_info> db = dc.GetTable<db_test_info>(); db_test_info info=db.SingleOrDefault(s => s.t_name == name); if (info == null) return; info.t_name=newname; dc.SubmitChanges(); } } } public static void Delete(string name) { using (SqlConnection conn = new SqlConnection(m_conn_str)) { using (DataContext dc = new DataContext(conn)) { Table<db_test_info> db = dc.GetTable<db_test_info>(); db_test_info info = db.SingleOrDefault(s => s.t_name == name); if (info != null) { db.DeleteOnSubmit(info); dc.SubmitChanges(); } } } } public static void DeleteBatchSame(string name) { using (SqlConnection conn = new SqlConnection(m_conn_str)) { using (DataContext dc = new DataContext(conn)) { Table<db_test_info> db = dc.GetTable<db_test_info>(); IEnumerable<db_test_info> result = from s in db where s.t_name == name select s; if (result != null) { db.DeleteAllOnSubmit(result); dc.SubmitChanges(); } } } } static void Main(string[] args) { New("张大拿"); New("刘勇"); New("刘明"); Update("张大拿", "老王"); Update("刘明", "刘勇"); DeleteBatchSame("刘勇"); } } }
Linq To Sql 增改删
标签:rgs let using rate select int mod key namespace
本文系统来源:http://www.cnblogs.com/lxjshuju/p/7135845.html
内容总结
以上是互联网集市为您收集整理的Linq To Sql 增改删全部内容,希望文章能够帮你解决Linq To Sql 增改删所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。