public void create_basic_connectionString_with_IntegratedSecurity()
{
SqlServerConnectionString sqlServerConnectionStringExpected = new SqlServerConnectionString()
{
Server = "server",
Database = "database",
IntegratedSecurity = true
};
SqlServerConnectionString sqlServerConnectionStringBuilder = new SqlServerConnectionStringBuilder("server", "database");
Assert.AreEqual(sqlServerConnectionStringExpected.GetConnectionString(), sqlServerConnectionStringBuilder.GetConnectionString());
}
public void not_add_User_and_no_removes_IntegratedSecurity_to_ConnectionString_when_User_is_Empty()
{
SqlServerConnectionString sqlServerConnectionStringExpected = new SqlServerConnectionString()
{
Server = "server",
Database = "database",
IntegratedSecurity = true
};
SqlServerConnectionString sqlServerConnectionStringBuilder =
new SqlServerConnectionStringBuilder("server", "database").WithUser(string.Empty);
Assert.AreEqual(sqlServerConnectionStringExpected.GetConnectionString(), sqlServerConnectionStringBuilder.GetConnectionString());
}
public void add_User_and_removes_IntegratedSecurity_to_ConnectionString_when_User_contains_text()
{
SqlServerConnectionString sqlServerConnectionStringExpected = new SqlServerConnectionString()
{
Server = "server",
Database = "database",
User = "******"
};
SqlServerConnectionString sqlServerConnectionStringBuilder =
new SqlServerConnectionStringBuilder("server", "database").WithUser("user");
Assert.AreEqual(sqlServerConnectionStringExpected.GetConnectionString(), sqlServerConnectionStringBuilder.GetConnectionString());
}
public void remove_User_and_Password_when_sets_true_IntegratedSecurity()
{
SqlServerConnectionString sqlServerConnectionStringExpected = new SqlServerConnectionString()
{
Server = "server",
Database = "database",
IntegratedSecurity = true
};
SqlServerConnectionString sqlServerConnectionStringBuilder =
new SqlServerConnectionStringBuilder("server", "database", "user", "password").WithIntegratedSecurity(true);
Assert.AreEqual(sqlServerConnectionStringExpected.GetConnectionString(), sqlServerConnectionStringBuilder.GetConnectionString());
}
public void create_basic_connectionString_with_User_and_Password()
{
SqlServerConnectionString sqlServerConnectionStringExpected = new SqlServerConnectionString()
{
Server = "server",
Database = "database",
User = "******",
Password = "******"
};
SqlServerConnectionString sqlServerConnectionStringBuilder = new SqlServerConnectionStringBuilder("server", "database", "user", "password");
Assert.AreEqual(sqlServerConnectionStringExpected.GetConnectionString(), sqlServerConnectionStringBuilder.GetConnectionString());
}
public void not_add_Password_and_no_removes_IntegratedSecurity_to_ConnectionString_when_Password_is_Null()
{
SqlServerConnectionString sqlServerConnectionStringExpected = new SqlServerConnectionString()
{
Server = "server",
Database = "database",
IntegratedSecurity = true
};
SqlServerConnectionString sqlServerConnectionStringBuilder =
new SqlServerConnectionStringBuilder("server", "database").WithPassword(null);
Assert.AreEqual(sqlServerConnectionStringExpected.GetConnectionString(), sqlServerConnectionStringBuilder.GetConnectionString());
}
public void should_create_connectionString_from_sqlServerConfiguration()
{
var connectionStringConfiguration = new SqlServerDbSandboxConnectionString()
{
DataSourcePath = ".",
IntegratedSecurity = true
};
var connectionStringBuilder = new SqlServerConnectionStringBuilder(connectionStringConfiguration);
var connectionString = connectionStringBuilder.Build();
connectionString.Should().Contain("Data Source=.");
connectionString.Should().Contain("Initial Catalog=master");
connectionString.Should().Contain("Integrated Security=True");
}
public void add_WithTrustedConnection_to_ConnectionString()
{
SqlServerConnectionString sqlServerConnectionStringExpected = new SqlServerConnectionString()
{
Server = "server",
Database = "database",
IntegratedSecurity = true,
TrustedConnection = true
};
SqlServerConnectionString sqlServerConnectionStringBuilder =
new SqlServerConnectionStringBuilder("server", "database").WithTrustedConnection(true);
Assert.AreEqual(sqlServerConnectionStringExpected.GetConnectionString(), sqlServerConnectionStringBuilder.GetConnectionString());
}
public void add_MultipleActiveResultSets_to_ConnectionString()
{
SqlServerConnectionString sqlServerConnectionStringExpected = new SqlServerConnectionString()
{
Server = "server",
Database = "database",
IntegratedSecurity = true,
MultipleActiveResultSets = true
};
SqlServerConnectionString sqlServerConnectionStringBuilder =
new SqlServerConnectionStringBuilder("server", "database").WithMultipleActiveResultSets(true);
Assert.AreEqual(sqlServerConnectionStringExpected.GetConnectionString(), sqlServerConnectionStringBuilder.GetConnectionString());
}
public void should_create_connectionString_with_userId_and_password()
{
var connectionStringConfiguration = new SqlServerDbSandboxConnectionString()
{
DataSourcePath = ".",
UserName = "******",
Password = "******",
};
var connectionStringBuilder = new SqlServerConnectionStringBuilder(connectionStringConfiguration);
var connectionString = connectionStringBuilder.Build();
connectionString.Should().Contain("Data Source=.");
connectionString.Should().Contain("Initial Catalog=master");
connectionString.Should().Contain("User ID");
connectionString.Should().Contain("Password");
}
public void should_create_connectionString_when_send_dbName()
{
const string dbName = "dbName";
string expectedInitialCatalog = $"Initial Catalog={dbName}";
var connectionStringConfiguration = new SqlServerDbSandboxConnectionString()
{
DataSourcePath = ".",
UserName = "******",
Password = "******"
};
var connectionStringBuilder = new SqlServerConnectionStringBuilder(connectionStringConfiguration);
var connectionString = connectionStringBuilder.Build(dbName);
connectionString.Should().Contain("Data Source=.");
connectionString.Should().Contain(expectedInitialCatalog);
connectionString.Should().Contain("User ID");
connectionString.Should().Contain("Password");
}
