public List<CAUHOIKHAOSAT> SelectCAUHOIKHAOSATsAll() { List<CAUHOIKHAOSAT> list = new List<CAUHOIKHAOSAT>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { ISingleResult<CAUHOIKHAOSAT_getallResult> lp = db.CAUHOIKHAOSAT_getall(); foreach (CAUHOIKHAOSAT_getallResult CAUHOIKHAOSAT in lp) { CAUHOIKHAOSAT var1 = new CAUHOIKHAOSAT(); var1.MaCauHoiKhaoSat = CAUHOIKHAOSAT.MaCauHoiKhaoSat ; var1.NoiDung = CAUHOIKHAOSAT.NoiDung ; var1.BiKhoa = CAUHOIKHAOSAT.BiKhoa ; list.Add(var1); } try { // Save the changes. db.SubmitChanges(); } // Detect concurrency conflicts. catch (ChangeConflictException) { // Resolve conflicts. db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } } return list; }