linq To SQl之关联表同步添加数据

//关联表同步添加数据 ,如订单和订单详细；用户和用户组别

  protected void gvUser_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
        {
            ASPxTextBox currentText = ((ASPxGridView)sender).FindEditFormTemplateControl("txtUserName") as ASPxTextBox;
            ASPxTextBox UserPWD = ((ASPxGridView)sender).FindEditFormTemplateControl("txtUserPWD") as ASPxTextBox;
            ASPxComboBox currentBox = ((ASPxGridView)sender).FindEditFormTemplateControl("cboUserGroup") as ASPxComboBox;
            string v = (string)currentBox.Value;

            Casagroup.Entities.User user = new Casagroup.Entities.User()
            {
                UserPWD = _common.EncryptToMD5(UserPWD.Text),
                UserName = currentText.Text,
            };

            Casagroup.Entities.UserGroupUser userGroupUser = new Casagroup.Entities.UserGroupUser()
            {
                UserID = user.UserID,  //相当于下订单时，返回的订单号，再来插入订单详细项
                UserGroupID = int.Parse(v)
            };

            user.UserGroupUser.Add(userGroupUser);//先做关联添加工作

            eDataContext.User.InsertOnSubmit(user);//再做主表插入工作

            eDataContext.SubmitChanges(); //提交即可
 
            e.Cancel = true;
            this.gvUser.CancelEdit();
            BindUserInfo();
        }