public List<LOAIHOATDONG> SelectLOAIHOATDONGsAll() { List<LOAIHOATDONG> list = new List<LOAIHOATDONG>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { ISingleResult<LOAIHOATDONG_getallResult> lp = db.LOAIHOATDONG_getall(); foreach (LOAIHOATDONG_getallResult LOAIHOATDONG in lp) { LOAIHOATDONG var1 = new LOAIHOATDONG(); var1.MaLoaiHoatDong = LOAIHOATDONG.MaLoaiHoatDong ; var1.TenLoaiHoatDong = LOAIHOATDONG.TenLoaiHoatDong ; list.Add(var1); } try { // Save the changes. db.SubmitChanges(); } // Detect concurrency conflicts. catch (ChangeConflictException) { // Resolve conflicts. db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } } return list; }