LINQ基本查询

1：

 

protected void Page_Load(object sender, EventArgs e)

        {

            MyLinqDataContext dc = new MyLinqDataContext ();                                                  // 创建对象

            var StudentList = from d in dc.Student orderby d.S_ID descending select d;                   // 执行查询

            foreach (var stu in StudentList)                                                                                         // 遍历元素

            {

                Response.Write(" 学生姓名为 " + stu.S_NAME.ToString()+"<br/>");                    // 输出 HTML 字串

            }

        }                                         

 

 

 

  public void InsertSQL()

        {

            Student stu = new Student { S_NAME="xixi",C_ID=1,S_CLASS="0502" };    // 创建一个数据对象

            MyLinqDataContext dc = new MyLinqDataContext();                                         // 创建一个数据连接

            dc.Student.InsertOnSubmit(stu);                                                                             // 执行插入数据操作

            dc.SubmitChanges();                                                                                                // 执行更新操作

        }

 

 

 

 

public void UpdateSQL()

        {

            MyLinqDataContext dc = new MyLinqDataContext();

            var element = from d in dc.Student where d.S_ID == 4 select d;                                        // 查询

            foreach (var e in element)                                                                                                          // 遍历集合

            {

                e.S_NAME = "xixi2";                                                                                                             // 修改值

                e.S_CLASS = "0501";                                                                                                          // 修改值

            }

            dc.SubmitChanges();                                                                                                                   // 更新

        }

 

 

 

 

public void DeleteSQL()

        {

            MyLinqDataContext dc = new MyLinqDataContext();                                                  // 连接数据源

            var del = from d in dc.Student where d.S_ID == 4 select d;                                        // 查询要删除的行

            foreach (var e in del)                                                                                                          // 遍历集合

            {

                dc.Student.DeleteOnSubmit(e);                                                                               // 执行删除操作

            }

 

        }

 

public void DeleteSQL()

        {

            MyLinqDataContext dc = new MyLinqDataContext();

            var delf = from d in dc.Class where d.C_ID == 1 select d;                                 // 查询父表

            var del = from d in dc.Student from f in dc.Class where d.S_ID ==

            4 && f.C_ID==1&&d.S_ID==f.C_ID select d;                                                                 // 进行约束查询

            foreach (var e in del)                                                                                                 // 删除子表

            {

                dc.Student.DeleteOnSubmit(e);                                                                      // 删除对象

                dc.SubmitChanges();                                                                                        // 更新删除

            }

            foreach (var f in delf)                                                                                                 // 删除父表

            {

                dc.Class.DeleteOnSubmit(f);                                                                                    // 删除对象

                dc.SubmitChanges();                                                                                        // 更新删除

            }

        }

 

 

2：

 

 

protected void Page_Load(object sender, EventArgs e)

        {

            DataContext db = new DataContext("Data Source=(local);

            Initial Catalog=student;Persist Security Info=True;User ID=sa;Password=sa");// 建立连接

            try

            {

                Table<Student> stu = db.GetTable<Student>();                                          // 获取相应表的数据

                 var StudentList = from d in stu orderby d.S_ID descending select d;      // 执行 LINQ 查询

                foreach (var stud in StudentList)                                                                     // 遍历集合

                {

                    Response.Write(" 学生姓名为 " + stud.S_NAME.ToString() + "<br/>");// 输出对象

                 }

            }

            catch

            {

                Response.Write(" 数据库连接失败 ");                                                                // 抛出异常

            }

        }