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();
}
}
}