protected void GivenANewTestSqlDbWithASingleEntity() { var dbServerName = LocalDbSetup.LocalDbServerName; var dbName = "RepositoryCanDoCrudStory"; _conString = $@"data source={dbServerName};initial catalog={ dbName };integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"; // delete any existing databases var dbSetup = new LocalDbSetup(Environment.CurrentDirectory, dbName); dbSetup.CreateLocalDb(true); // create db using (var repositoryDb = new TestModel(_conString)) { repositoryDb.MyEntities .Add(new MyEntity { Id = 1, Name = "Name", Date = _referencedate, Money = _referenceNumber }); repositoryDb.SaveChanges(); } // asser setup is complete using (var repositoryDb = new TestModel(_conString)) { var result = repositoryDb.MyEntities .FirstOrDefault(m => m.Name == "Name"); Assert.NotNull(result); } }
protected void GivenASqlDatabaseWithData() { _dbName = GetType().Name; var dbServerName = LocalDbSetup.LocalDbServerName; if (string.IsNullOrWhiteSpace(_dbName)) { throw new InvalidOperationException(); } _conString = $@"data source={dbServerName};initial catalog={ _dbName };integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"; // delete any existing databases var dbSetup = new LocalDbSetup(Environment.CurrentDirectory, _dbName); dbSetup.CreateLocalDb(true); using (var db = new BulkDeletesModel(_conString)) { db.Database.CreateIfNotExists(); for (int i = 0; i < 10; i++) { db.MyEntities.Add(new MyEntity() { Id = i, Name = "Name" + i }); } db.SaveChanges(); } }