public List<KHAOSAT> SelectKHAOSATsAll() { List<KHAOSAT> list = new List<KHAOSAT>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { ISingleResult<KHAOSAT_getallResult> lp = db.KHAOSAT_getall(); foreach (KHAOSAT_getallResult KHAOSAT in lp) { KHAOSAT var1 = new KHAOSAT(); var1.MaDapAn = KHAOSAT.MaDapAn ; var1.MaYKKS = KHAOSAT.MaYKKS ; var1.YKienKhac = KHAOSAT.YKienKhac ; list.Add(var1); } try { // Save the changes. db.SubmitChanges(); } // Detect concurrency conflicts. catch (ChangeConflictException) { // Resolve conflicts. db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } } return list; }