public List<DANGKYHOATDONG_getallResult> SelectDANGKYHOATDONGsAll() { List<DANGKYHOATDONG_getallResult> list = new List<DANGKYHOATDONG_getallResult>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { ISingleResult<DANGKYHOATDONG_getallResult> lp = db.DANGKYHOATDONG_getall(); foreach (DANGKYHOATDONG_getallResult DANGKYHOATDONG in lp) { DANGKYHOATDONG_getallResult var1 = new DANGKYHOATDONG_getallResult(); var1.MaHoatDong = DANGKYHOATDONG.MaHoatDong ; var1.MaNguoiDung = DANGKYHOATDONG.MaNguoiDung ; var1.Username = DANGKYHOATDONG.Username; var1.TenHoatDong = DANGKYHOATDONG.TenHoatDong; list.Add(var1); } try { // Save the changes. db.SubmitChanges(); } // Detect concurrency conflicts. catch (ChangeConflictException) { // Resolve conflicts. db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } } return list; }