public static FlightInfoDbContext Create()
{
var options = new DbContextOptionsBuilder <FlightInfoDbContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
var context = new FlightInfoDbContext(options);
context.Database.EnsureCreated();
context.Airports.AddRange(new[] {
new Airport {
AirportId = 1, Name = "Chris Hadfield Airport", City = "Sarnia", Country = "Canada", IATA = "YZR", ICAO = "CYZR", Longitude = 42.9994010925293M, Altitude = -82.30889892578125M
},
new Airport {
AirportId = 2, Name = "Leicester Airport", City = "Leicester", Country = "United Kingdom", IATA = string.Empty, ICAO = "EGBG", Longitude = 52.6077995300293M, Altitude = 1.03193998336792M
},
new Airport {
AirportId = 3, Name = "RAF Wyton", City = "Wyton", Country = "United Kingdom", IATA = "QUY", ICAO = "EGUY", Longitude = 52.3572006226M, Altitude = -0.107832998037M
},
new Airport {
AirportId = 4, Name = "Lidköping-Hovby Airport", City = "Lidkoping", Country = "Sweden", IATA = "LDK", ICAO = "ESGL", Longitude = 58.4655M, Altitude = 13.1744M
}
});
context.Flights.AddRange(new[] {
new Flight {
DepartureAirportId = 1, DestinationAirportId = 4, FuelConsumption = 10M
},
});
context.SaveChanges();
return(context);
}
public FlightInfoDbContext GetDbContext(bool useSqlLite = false)
{
var builder = new DbContextOptionsBuilder <FlightInfoDbContext>();
if (useSqlLite)
{
builder.UseSqlite("DataSource=:memory:", x => { });
}
else
{
builder.UseInMemoryDatabase(Guid.NewGuid().ToString());
}
var dbContext = new FlightInfoDbContext(builder.Options);
if (useSqlLite)
{
// SQLite needs to open connection to the DB.
// Not required for in-memory-database.
dbContext.Database.OpenConnection();
}
dbContext.Database.EnsureCreated();
return(dbContext);
}
static void Main(string[] args)
{
var builder = new DbContextOptionsBuilder <FlightInfoDbContext>();
FlightInfoDbContext context = new FlightInfoDbContext(builder.Options);
FlightInfoInitializer.Initialize(context);
}
public AirportSearchQueryHandlerTest(QueryTestFixture fixture)
{
_context = fixture.Context;
var myProfile = new AutoMapperProfile();
var configuration = new MapperConfiguration(cfg => cfg.AddProfile(myProfile));
_mapper = new Mapper(configuration);
}
public AirportSearchQueryHandler(FlightInfoDbContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public GetFuelConsumptionQueryHandler(FlightInfoDbContext context)
{
_context = context;
}
public static void Initialize(FlightInfoDbContext context)
{
var initializer = new FlightInfoInitializer();
}
public UpdateFlightCommandHandlerTest(QueryTestFixture fixture)
{
_context = fixture.Context;
}
public FlightInfoHandler(FlightInfoDbContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public UpdateFlightCommandHandler(FlightInfoDbContext context)
{
_context = context;
}
public static void Destroy(FlightInfoDbContext context)
{
context.Database.EnsureDeleted();
context.Dispose();
}
public GetFuelConsumptionQueryHandlerTest(QueryTestFixture fixture)
{
_context = fixture.Context;
}
public QueryTestFixture()
{
Context = FlightInfoDbContextFactory.Create();
}
