public void BasicDatabaseTest() { // Arrange var connectionStringBuilder = new SqliteConnectionStringBuilder { DataSource = ":memory:" }; var connection = new SqliteConnection(connectionStringBuilder.ToString()); var options = new DbContextOptionsBuilder <ClimbingRoutesContext>() .UseSqlite(connection) .Options; using (var context = new ClimbingRoutesContext(options)) { context.Database.OpenConnection(); context.Database.EnsureCreated(); context.Users.Add(new Climber() { FirstName = "Matthew", LastName = "??", Email = "*****@*****.**" }); context.Users.Add(new Climber() { FirstName = "Mark", LastName = "??", Email = "*****@*****.**" }); context.Users.Add(new Climber() { FirstName = "Luke", LastName = "??", Email = "*****@*****.**" }); context.Users.Add(new Climber() { FirstName = "John", LastName = "??", Email = "*****@*****.**" }); context.SaveChanges(); } int numUser; // Three are added in the seed data. For a total of 7... int expected = 7; using (var context = new ClimbingRoutesContext(options)) { // Act numUser = context.Users.ToList().Count; } // Assert Assert.Equal(numUser, expected); }
public ClimbersController(ClimbingRoutesContext context, IMapper mapper) { _context = context ?? throw new ArgumentNullException(nameof(context)); context.Database.OpenConnection(); context.Database.EnsureCreated(); _mapper = mapper ?? throw new ArgumentNullException(nameof(mapper)); _set = context.Set <Climber>(); }
public static ClimbingRoutesContext GetNewContext() { var connectionStringBuilder = new SqliteConnectionStringBuilder { DataSource = ":memory:" }; var connection = new SqliteConnection(connectionStringBuilder.ToString()); var options = new DbContextOptionsBuilder <ClimbingRoutesContext>() .UseSqlite(connection) .Options; var context = new ClimbingRoutesContext(options); context.Database.OpenConnection(); context.Database.EnsureCreated(); return(context); }