public void SqlConnectionFactory_throws_if_given_MDF_filename()
{
var factory = new SqlConnectionFactory();
Assert.Equal(
Strings.SqlConnectionFactory_MdfNotSupported("FakeDatabaseName.mdf"),
Assert.Throws <NotSupportedException>(() => factory.CreateConnection("FakeDatabaseName.mdf")).Message);
}
public void SqlConnectionFactory_creates_SqlConnection()
{
var factory = new SqlConnectionFactory();
var connection = factory.CreateConnection("FakeDatabaseName");
Assert.IsType <SqlConnection>(connection);
}
public void SqlConnectionFactory_uses_database_name_as_initial_catalog()
{
var factory = new SqlConnectionFactory();
var connection = factory.CreateConnection("FakeDatabaseName");
Assert.True(connection.ConnectionString.Contains("Initial Catalog=FakeDatabaseName"));
AssertConnectionStringHasDefaultParts(connection.ConnectionString);
}
public void SqlConnectionFactory_replaces_any_initial_catalog_set_in_the_base_connection()
{
var factory = new SqlConnectionFactory(
@"Data Source=.\SQLEXPRESS; Integrated Security=True; Initial Catalog=TheManWithTheStick");
var connection = factory.CreateConnection("FakeDatabaseName");
Assert.False(connection.ConnectionString.Contains("Initial Catalog=TheManWithTheStick"));
Assert.True(connection.ConnectionString.Contains("Initial Catalog=FakeDatabaseName"));
}
public void SqlConnectionFactory_uses_changed_base_connection_string_when_creating_connection_string()
{
var factory = new SqlConnectionFactory("Data Source=190.190.200.100,1433");
Assert.Equal("Data Source=190.190.200.100,1433", factory.BaseConnectionString);
var connection = factory.CreateConnection("FakeDatabaseName");
Assert.True(connection.ConnectionString.Contains("Data Source=190.190.200.100,1433"));
Assert.True(connection.ConnectionString.Contains("Initial Catalog=FakeDatabaseName"));
}
public void SqlConnectionFactory_handles_no_provider_factory_found()
{
var factory = new SqlConnectionFactory
{
ProviderFactory = name => null
};
var connection = factory.CreateConnection("FakeDatabaseName");
Assert.Equal(typeof(SqlConnection), connection.GetType());
Assert.True(connection.ConnectionString.Contains("Initial Catalog=FakeDatabaseName"));
}
public void SqlConnectionFactory_handles_provider_factory_returning_null_connection()
{
var mockProviderFactory = new Mock <DbProviderFactory>();
mockProviderFactory.Setup(m => m.CreateConnection()).Returns <DbConnection>(null);
var factory = new SqlConnectionFactory
{
ProviderFactory = name => mockProviderFactory.Object
};
var connection = factory.CreateConnection("FakeDatabaseName");
Assert.Equal(typeof(SqlConnection), connection.GetType());
Assert.True(connection.ConnectionString.Contains("Initial Catalog=FakeDatabaseName"));
}
public void SqlConnectionFactory_uses_db_provider_factory()
{
var mockProviderFactory = new Mock <DbProviderFactory>();
var mockConnection = new Mock <DbConnection>();
mockConnection.SetupProperty(c => c.ConnectionString);
mockProviderFactory.Setup(m => m.CreateConnection()).Returns(mockConnection.Object);
var factory = new SqlConnectionFactory
{
ProviderFactory = name => mockProviderFactory.Object
};
var connection = factory.CreateConnection("FakeDatabaseName");
Assert.Same(mockConnection.Object, connection);
Assert.True(connection.ConnectionString.Contains("Initial Catalog=FakeDatabaseName"));
}