public void ShouldEqualFalse()
{
// Arrange
var connectionString = Helpers.GetRandomConnectionString();
var dbContext = new Context(connectionString);
try
{
Helpers.SetInitializer(new ContextInitializer(SeedContext));
dbContext.Database.Initialize(true); //necessary when not performing query through the EF api
// Act
var doesIdExist = dbContext.DoesIdExist<Home>("Id", Guid.NewGuid());
var actual = doesIdExist == false;
// Assert
Assert.IsTrue(actual);
}
catch { throw; }
finally { dbContext.Database.Delete(); }
}
public void ShouldEqualTrue()
{
// Arrange
var connectionString = Helpers.GetRandomConnectionString();
var dbContext = new Context(connectionString);
try
{
Helpers.SetInitializer(new ContextInitializer(SeedContext));
dbContext.Database.Initialize(true); //necessary when not performing query through the EF api
// Act
var doesIdExist = dbContext.DoesIdExist<Home>("Id", Guid.ParseExact("A7FBD140-1CE1-4D6F-9123-29142FDA9E8B", "D"));
var actual = doesIdExist == true;
// Assert
Assert.IsTrue(actual);
}
catch { throw; }
finally { dbContext.Database.Delete(); }
}
public void ShouldMatch()
{
// Arrange
var connectionString = Helpers.GetRandomConnectionString();
var dbContext = new Context(connectionString);
try
{
Helpers.SetInitializer(new ContextInitializer(SeedContext));
dbContext.Database.Initialize(true); //necessary when not performing query through the EF api
string expected, actual;
actual = dbContext.GetTableName<Home>();
expected = string.Format("{0}.{1}", Constants.DB_SCHEMA, "Homes");
Assert.AreEqual(expected, actual);
actual = dbContext.GetTableName<HomeOwner>();
expected = string.Format("{0}.{1}", Constants.DB_SCHEMA, "HomeOwners");
Assert.AreEqual(expected, actual);
}
catch { throw; }
finally { dbContext.Database.Delete(); }
}
public void ShouldEqualInsertedCount()
{
//Arrange
var connectionString = DataModelHelpers.GetRandomConnectionString();
var dbContext = new Context(connectionString);
try
{
Helpers.SetInitializer(new ContextInitializer(SeedContext));
using (var repository = new GenericDbRepository<Home, DataModel.Home>(_mapper, dbContext))
{
// Act
var data = repository.All();
// Assert
Assert.IsTrue(data.Any());
}
}
catch { throw; }
finally { dbContext.Database.Delete(); }
}
public void ShouldEqualInsertedCount()
{
var connectionString = DataModelHelpers.GetRandomConnectionString();
var dbContext = new Context(connectionString);
try
{
Helpers.SetInitializer(new ContextInitializer(context =>
{
using (var repository = new GenericDbRepository<Home, DataModel.Home>(_mapper, dbContext))
{
repository.Merge(new Home
{
Id = Guid.NewGuid(),
Address = ""
});
repository.Merge(new Home
{
Id = Guid.NewGuid(),
Address = ""
});
}
}));
using (var repository = new GenericDbRepository<Home, DataModel.Home>(_mapper, dbContext))
{
var expected = 2;
int? actual = 0;
repository.All(ref actual, pageSize: 1, pageIndex: 0);
Assert.AreEqual(expected, actual);
actual = repository.Count();
Assert.AreEqual(expected, actual);
}
}
catch { throw; }
finally { dbContext.Database.Delete(); }
}
public void ShouldConstruct()
{
var connectionString = DataModelHelpers.GetRandomConnectionString();
var dbContext = new Context(connectionString);
try
{
Helpers.SetInitializer(new ContextInitializer(context =>
{
using (var repository = new GenericDbRepository<Home, DataModel.Home>(_mapper, dbContext))
{
}
}));
dbContext.Database.Initialize(true); //necessary when not performing query through the EF api
}
catch { throw; }
finally { dbContext.Database.Delete(); }
}
public void ShouldRespectSorter()
{
//Arrange
var connectionString = DataModelHelpers.GetRandomConnectionString();
var dbContext = new Context(connectionString);
try
{
Helpers.SetInitializer(new ContextInitializer(SeedContext));
using (var repository = new GenericDbRepository<Home, DataModel.Home>(_mapper, dbContext))
{
// Act
var data = repository.All(sorters: new SortHomes(SortOrder.ASC, dateBuilt: true)).ToList();
// Assert
Assert.IsTrue(data.Any());
Assert.AreEqual(new DateTime(1982, 5, 1), data.First().DateBuilt);
}
}
catch { throw; }
finally { dbContext.Database.Delete(); }
}
public void ShouldRespectFilter()
{
//Arrange
var connectionString = DataModelHelpers.GetRandomConnectionString();
var dbContext = new Context(connectionString);
try
{
Helpers.SetInitializer(new ContextInitializer(SeedContext));
using (var repository = new GenericDbRepository<Home, DataModel.Home>(_mapper, dbContext))
{
// Act
var data = repository.All(new FilterHomes(roomNames: new[]{"Dining Room"})).ToList();
// Assert
Assert.IsTrue(data.Any());
Assert.AreEqual(2, data.Count());
}
}
catch { throw; }
finally { dbContext.Database.Delete(); }
}
