LinQ(删除)

public partial class Default3 : System.Web.UI.Page
{
    NorthwindDBDataContext dc = new NorthwindDBDataContext();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack)
            return;
        Bind();
      
    }

    private void Bind()
    {
        GridView1.DataSource = dc.Users;
        GridView1.DataBind();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {

        //创建用户对象
        string username = TextBox1.Text;
        string password = TextBox2.Text;
        bool sex = CheckBox1.Checked;

        Users user = new Users() { Username = username, Password = password, Sex = sex };

            //  添加到数据库中
        dc.Users.InsertOnSubmit(user);

        //一次性插入多条数据
        //List<Users> list=new List<Users>(){ user};
        //dc.Users.InsertAllOnSubmit(list);

        //提交更新
        dc.SubmitChanges();

        Bind();

    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string id=GridView1.DataKeys[e.RowIndex].Value.ToString();


        var result = from u in dc.Users
                     where u.Id.ToString() == id
                     select u;


        //删除集合
        dc.Users.DeleteAllOnSubmit(result);
        
        //删单个实体
        //dc.Users.DeleteOnSubmit(result.First());


        dc.SubmitChanges();

        Bind();
     
    }
}