public List<HOATDONG> SelectHOATDONGsAll() { List<HOATDONG> list = new List<HOATDONG>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { ISingleResult<HOATDONG_getallResult> lp = db.HOATDONG_getall(); foreach (HOATDONG_getallResult HOATDONG in lp) { HOATDONG var1 = new HOATDONG(); var1.MaHoatDong = HOATDONG.MaHoatDong ; var1.TenHoatDong = HOATDONG.TenHoatDong ; var1.NgayDienRa = HOATDONG.NgayDienRa ; var1.MaLoaiHoatDong = HOATDONG.MaLoaiHoatDong ; var1.ThoiGianBatDauDangKy = HOATDONG.ThoiGianBatDauDangKy ; var1.ThoiGianKetThucDangKy = HOATDONG.ThoiGianKetThucDangKy ; var1.HinhAnh = HOATDONG.HinhAnh; list.Add(var1); } try { // Save the changes. db.SubmitChanges(); } // Detect concurrency conflicts. catch (ChangeConflictException) { // Resolve conflicts. db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } } return list; }