public async Task CreateConnection_Creates_A_Sql_Connection() { // Arrange using (var api = new SqlLocalDbApi(_loggerFactory)) { using (TemporarySqlLocalDbInstance temporary = api.CreateTemporaryInstance(deleteFiles: true)) { ISqlLocalDbInstanceManager manager = temporary.Manage(); manager.ShouldNotBeNull(); manager.Name.ShouldBe(temporary.Name); // Act using (SqlConnection actual = manager.CreateConnection()) { // Assert actual.ShouldNotBeNull(); actual.ConnectionString.ShouldNotBeNull(); actual.State.ShouldBe(ConnectionState.Closed); await actual.OpenAsync(); actual.Close(); } } } }
public void Restart_Stops_And_Starts_Instance() { // Arrange using var api = new SqlLocalDbApi(_loggerFactory); using TemporarySqlLocalDbInstance temporary = api.CreateTemporaryInstance(deleteFiles: true); ISqlLocalDbInstanceManager manager = temporary.Manage(); // Act manager.Restart(); // Assert temporary.GetInstanceInfo().IsRunning.ShouldBeTrue(); }