LINQ

        我创建的LINQ to SQL 文件名为 LinqDB，具体代码如下：

        LinqDBDataContext lqdb = new LinqDBDataContext(ConfigurationManager.ConnectionStrings["db_LinqConnectionString"].ToString());
        tb_User user = new tb_User();
        //*********************************************
        //添加内容
        user.useraName = "阿希达";
        user.userPwd = "0704";
        //执行添加
        lqdb.tb_User.InsertOnSubmit(user);
        lqdb.SubmitChanges();
        //************************************************
        //修改数据
        var upd = from u in lqdb.tb_User where u.ID == 4 select u;
        foreach (tb_User useru in upd)
        {
            useru.userPwd = "20120704";
        }
        lqdb.SubmitChanges();

        //删除数据
        var dl = from d in lqdb.tb_User where d.ID == 3 select d;
        lqdb.tb_User.DeleteAllOnSubmit(dl);
        lqdb.SubmitChanges();
        //***********************************************
        //查询内容并绑定gridview控件之上
        var result = from f in lqdb.tb_User where f.ID > 0 select f;
        GridView1.DataSource = result;
        GridView1.DataBind();