public bool DeleteCompania(Compania compania) { var c = db.Companias.FirstOrDefault(g => g.Id == compania.Id); try { db.Companias.Remove(c); db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public static void TestingTXBeginEnd() { //https://msdn.microsoft.com/en-us/library/dn456843(v=vs.113).aspx using (var context = new SQLContexto()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { context.Database.ExecuteSqlCommand($"SELECT * FROM Companias"); var consulta = context.Companias; foreach (var i in consulta) { i.Calificacion = 100000; } context.SaveChanges(); dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }
public static void TestingTXScopes() { var testContext = new SqlAnalisisContexto(); var db = new SQLContexto(); using (var scope = new TransactionScope(TransactionScopeOption.Required)) { try { var q = db.Companias; db.SaveChanges(); var q1 = db.Companias; var c1 = q1.FirstOrDefault(); c1.Ruc = "Nuevo"; var c2 = new Compania() { Id = Guid.NewGuid() }; db.Companias.Add(c2); db.SaveChanges(); var q2 = db.Companias; var c3 = q2.FirstOrDefault(); db.Companias.Remove(c3); db.SaveChanges(); var aq = testContext.Rutas.Add(new Ruta() { Id = Guid.NewGuid() }); testContext.SaveChanges(); scope.Complete(); } catch { scope.Dispose(); } } }