public void RemovesBrandCorrect()
{
using (var dataWarehouseContext = new EFDataWarehouseContext())
{
using (var transaction = dataWarehouseContext.Database.BeginTransaction())
{
var brand = new Brand {
Name = "KIA"
};
dataWarehouseContext.Set <Brand>().Add(brand);
dataWarehouseContext.SaveChanges();
Assert.IsNotNull(dataWarehouseContext.Entry(brand));
dataWarehouseContext.Set <Brand>().Remove(brand);
dataWarehouseContext.SaveChanges();
Assert.IsNull(dataWarehouseContext.Set <Brand>()
.FirstOrDefault(b => b.Id == brand.Id));
transaction.Rollback();
}
}
}
public void UpdatesModelCorrect()
{
using (var dataWarehouseContext = new EFDataWarehouseContext())
{
using (var transaction = dataWarehouseContext.Database.BeginTransaction())
{
var brand = new Brand {
Name = "KIA"
};
dataWarehouseContext.Set <Brand>().Add(brand);
dataWarehouseContext.SaveChanges();
var model = new Model {
Name = "Rio", Brand = brand
};
dataWarehouseContext.Set <Model>().Add(model);
dataWarehouseContext.SaveChanges();
Assert.IsNotNull(dataWarehouseContext.Entry(model));
var expectedResult = model.Name = "Sportage";
dataWarehouseContext.Entry(model).State = EntityState.Modified;
dataWarehouseContext.SaveChanges();
Assert.AreEqual(expectedResult, dataWarehouseContext.Entry(model).Entity.Name);
transaction.Rollback();
}
}
}
public void UpdatesBrandCorrect()
{
using (var dataWarehouseContext = new EFDataWarehouseContext())
{
using (var transaction = dataWarehouseContext.Database.BeginTransaction())
{
var brand = new Brand {
Name = "KIA"
};
dataWarehouseContext.Set <Brand>().Add(brand);
dataWarehouseContext.SaveChanges();
Assert.IsNotNull(dataWarehouseContext.Entry(brand));
var expectedResult = brand.Name = "Toyota";
dataWarehouseContext.Entry(brand).State = EntityState.Modified;
dataWarehouseContext.SaveChanges();
Assert.AreEqual(expectedResult, dataWarehouseContext.Entry(brand).Entity.Name);
transaction.Rollback();
}
}
}
public void CreatesNewModelCorrect()
{
using (var dataWarehouseContext = new EFDataWarehouseContext())
{
using (var transaction = dataWarehouseContext.Database.BeginTransaction())
{
var brand = new Brand {
Name = "KIA"
};
dataWarehouseContext.Set <Brand>().Add(brand);
dataWarehouseContext.SaveChanges();
var model = new Model {
Name = "Rio", Brand = brand
};
dataWarehouseContext.Set <Model>().Add(model);
dataWarehouseContext.SaveChanges();
Assert.IsNotNull(dataWarehouseContext.Entry(model));
transaction.Rollback();
}
}
}