LINQ to SQL

最新推荐文章于 2024-10-06 20:39:51 发布

allenlily

最新推荐文章于 2024-10-06 20:39:51 发布

阅读量337

点赞数

分类专栏： LINQ 文章标签： linq table string button object sql

本文链接：https://blog.csdn.net/allenlily/article/details/7521623

版权

LINQ 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

1.控制台

static void Main(string[] args)
        {
            string dateDir = AppDomain.CurrentDomain.BaseDirectory;
            if (dateDir.EndsWith(@"\bin\Debug\") || dateDir.EndsWith(@"\bin\Debug\"))
            {
                dateDir = System.IO.Directory.GetParent(dateDir).Parent.Parent.FullName;
                AppDomain.CurrentDomain.SetData("DataDirectory", dateDir);
            }

            DataClasses1DataContext db = new DataClasses1DataContext();
            Table1 table = new Table1();           
            table.Name = "sfdsf";
            table.Age = 33;
            db.Table1.InsertOnSubmit(table);
            db.Log = Console.Out;
            db.SubmitChanges();
            Console.ReadLine();
        }

2.Winform

  static void Main()
        {
            string dateDir = AppDomain.CurrentDomain.BaseDirectory;
            if (dateDir.EndsWith(@"\bin\Debug\") || dateDir.EndsWith(@"\bin\Debug\"))
            {
                dateDir = System.IO.Directory.GetParent(dateDir).Parent.Parent.FullName;
                AppDomain.CurrentDomain.SetData("DataDirectory", dateDir);
            }
            Application.EnableVisualStyles();
            Application.SetCompatibleTextRenderingDefault(false);
            Application.Run(new Form1());
        }

按钮事件：

        private void button1_Click(object sender, EventArgs e)
        {
            DataClassesTestDataContext db = new DataClassesTestDataContext();
            var test = new Test {Name = "allen",
            Age = 24};
           
            db.Test.InsertOnSubmit(test);
            db.SubmitChanges();
        }

3.web

不需要编写那段拼接字符

按钮事件：

        protected void Button1_Click(object sender, EventArgs e)
        {
            DataClasseswebDataContext db = new DataClasseswebDataContext();
            Linqweb linqweb = new Linqweb();
            linqweb.Age = 33;
            linqweb.Name = "allen";
            db.Linqweb.InsertOnSubmit(linqweb);
            db.SubmitChanges();
        }