將最美的計算機軟件奉獻給社會

DataContext dbContext = new DataContext("data Source=192.168.0.66;database=LSS1;user id=sa;pwd=xit");

         //User為 數(shù)據(jù)映射類
        Table<User> users = dbContext.GetTable<User>();

        var result = from user in users
                     where user.UserName == this.txtUserName.Text.Trim()  //刪除條件
                     select user;

       //執(zhí)行刪除操作

        users.DeleteAllOnSubmit(result);
        dbContext.SubmitChanges();