public void can_get_animals_using_explicit_relationship_between_animal_and_enclosure()
{
using (var sandbox = new LocalDb())
{
Runner.MigrateToLatest(sandbox.ConnectionString);
using (var context = new ZooDbContext(sandbox.ConnectionString))
{
var enclosure = new Enclosure()
{
Id = 1, Name = "Kenya", Location = "Africa", Environment = "Sahara"
};
var animal = new Animal()
{
Name = "Nala", Species = "Lion", EnclosureId = 1
};
context.Animals.Add(animal);
context.Enclosures.Add(enclosure);
context.SaveChanges();
var controller = new HomeController()
{
Database = context
};
var result = controller.Index() as ViewResult;
var model = result == null ? new IndexViewModel() : result.Model as IndexViewModel;
Assert.Equal(1, model.Animals.Count());
Assert.Equal("Nala", model.Animals.First().AnimalName);
}
}
}
public void Can_throw_an_exception()
{
using (var sandbox = new LocalDb())
{
Runner.MigrateToLatest(sandbox.ConnectionString);
using (var one = new ZooDbContext(sandbox.ConnectionString))
{
var enclosure = new Enclosure {
Environment = "Here", Name = "One", Location = "Here"
};
one.Enclosures.Add(enclosure);
one.SaveChanges();
using (var two = new ZooDbContext(sandbox.ConnectionString))
{
var change = two.Enclosures.Find(enclosure.Id);
change.Name = "Changed";
two.SaveChanges();
}
enclosure.Name = "Last Time";
Assert.Throws <DbUpdateConcurrencyException>(() => one.SaveChanges());
}
}
}
public void can_get_animals_using_explicit_relationship_between_animal_and_enclosure()
{
using (var sandbox = new LocalDb())
{
Runner.MigrateToLatest(sandbox.ConnectionString);
using (var context = new ZooDbContext(sandbox.ConnectionString))
{
var enclosure = new Enclosure() { Id = 1, Name = "Kenya", Location = "Africa", Environment = "Sahara" };
var animal = new Animal() { Name = "Nala", Species = "Lion", EnclosureId = 1 };
context.Animals.Add(animal);
context.Enclosures.Add(enclosure);
context.SaveChanges();
var controller = new HomeController() { Database = context };
var result = controller.Index() as ViewResult;
var model = result == null ? new IndexViewModel() : result.Model as IndexViewModel;
Assert.Equal(1, model.Animals.Count());
Assert.Equal("Nala", model.Animals.First().AnimalName);
}
}
}
static async Task Connection()
{
await Task.Run(() =>
{
IZooDbContext db = new ZooDbContext();
db.SaveChanges();
});
ZooDbContext.Connected = true;
}
public ActionResult Index()
{
using (var db = new ZooDbContext())
{
var model = new IndexViewModel
{
Animals = db.Animals.Select(x => new AnimalWithEnclosureModel
{
AnimalId = x.Id,
EnclosureId = x.EnclosureId,
AnimalName = x.Name,
EnclosureName = x.Enclosure.Name
}).ToList()
};
return(View(model));
}
}
public void Can_throw_an_exception()
{
using (var sandbox = new LocalDb())
{
Runner.MigrateToLatest(sandbox.ConnectionString);
using (var one = new ZooDbContext(sandbox.ConnectionString))
{
var enclosure = new Enclosure {Environment = "Here", Name = "One", Location = "Here"};
one.Enclosures.Add(enclosure);
one.SaveChanges();
using (var two = new ZooDbContext(sandbox.ConnectionString))
{
var change = two.Enclosures.Find(enclosure.Id);
change.Name = "Changed";
two.SaveChanges();
}
enclosure.Name = "Last Time";
Assert.Throws<DbUpdateConcurrencyException>(() => one.SaveChanges());
}
}
}
public AnimalsGatewayDb(ZooDbContext context)
{
_context = context;
}
public SmartDeviceService(ZooDbContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public AnimalTypeService(ZooDbContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public ZooServices(ZooDbContext context)
{
_context = context;
}
public AnimalDetailsService(ZooDbContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public WorkersGatewayDb(ZooDbContext context)
{
_context = context;
}
public EmployeeService(ZooDbContext dbContext, IMapper mapper)
{
_dbContext = dbContext;
_mapper = mapper;
}
public AnimalRepository(ZooDbContext context)
{
_context = context;
}
public FoodRepository(ZooDbContext context)
{
_context = context;
}
public ZooGatewayDb(ZooDbContext context)
{
_context = context;
}
public DeviceRecordService(ZooDbContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public AnimalService(ZooDbContext dbContext, IMapper mapper)
{
_dbContext = dbContext;
_mapper = mapper;
}
