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