public List<LOAIVAITRO> SelectLOAIVAITROsAll() { List<LOAIVAITRO> list = new List<LOAIVAITRO>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { ISingleResult<LOAIVAITRO_getallResult> lp = db.LOAIVAITRO_getall(); foreach (LOAIVAITRO_getallResult LOAIVAITRO in lp) { LOAIVAITRO var1 = new LOAIVAITRO(); var1.MaLoaiVaiTro = LOAIVAITRO.MaLoaiVaiTro ; var1.TenLoaiVaiTro = LOAIVAITRO.TenLoaiVaiTro ; list.Add(var1); } try { // Save the changes. db.SubmitChanges(); } // Detect concurrency conflicts. catch (ChangeConflictException) { // Resolve conflicts. db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } } return list; }