public void WhenPassingCorrectData_CreateSuccessfully(string name, int volume)
            {
                using (var dbContextFactory = new SqlLiteDbContextFactory())
                {
                    // Run the test against the instance of the context
                    using (var context = dbContextFactory.CreateContext())
                    {
                        var service = new TankService(context);
                        var tank    = InstantiateTank(name, volume);
                        service.Create(tank);
                    }

                    // Get another context using the same connection
                    using (var context = dbContextFactory.CreateContext())
                    {
                        var service = new TankService(context);
                        var tanks   = service.FindAll();
                        Assert.Equal(1, tanks.Count);
                        var tank = tanks.First();
                        Assert.NotNull(tank);
                        // TODO: uncomment below after fix and investigate why the navigation property 'Equipment' is not eager loaded
                        // AssertTank(tank, null, name, volume);
                    }
                }
            }
            public void WhenTankDoesNotExists_ReturnNone()
            {
                using (var factory = new SqlLiteDbContextFactory())
                {
                    using (var context = factory.CreateContext())
                    {
                        var service = new TankService(context);
                        var tanks   = service.FindAll();

                        Assert.Empty(tanks);
                    }
                }
            }
            public void WhenTankExists_ReturnAll()
            {
                using (var factory = new SqlLiteDbContextFactory())
                {
                    using (var context = factory.CreateContext())
                    {
                        SetupTestData(context);

                        var service = new TankService(context);
                        var tanks   = service.FindAll();

                        Assert.Equal(2, tanks.Count);
                    }
                }
            }