public List<TAPTINBAIVIET> getLichLamViec() { List<TAPTINBAIVIET> list = new List<TAPTINBAIVIET>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { ISingleResult<TAPTINBAIVIET_getLichLamViecResult> lp = db.TAPTINBAIVIET_getLichLamViec(); foreach (TAPTINBAIVIET_getLichLamViecResult TAPTINBAIVIET in lp) { TAPTINBAIVIET var1 = new TAPTINBAIVIET(); var1.MaTapTin = TAPTINBAIVIET.MaTapTin; var1.TenTapTin = TAPTINBAIVIET.TenTapTin; var1.DuongDan = TAPTINBAIVIET.DuongDan; var1.MaBaiViet = TAPTINBAIVIET.MaBaiViet; list.Add(var1); } try { // Save the changes. db.SubmitChanges(); } // Detect concurrency conflicts. catch (ChangeConflictException) { // Resolve conflicts. db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } } return list; }