public void generate_connectionString_with_basic_values()
{
SqlServerConnectionString sqlConnectionString = new SqlServerConnectionString();
string connectionString = sqlConnectionString.GetConnectionString();
Assert.AreEqual("Data Source=;Initial Catalog=;", connectionString);
}
public SqlServerConnectionStringBuilder(string server, string database)
{
sqlConnectionString = new SqlServerConnectionString()
{
Server = server,
Database = database,
IntegratedSecurity = true
};
}
public SqlServerConnectionStringBuilder(string server, string database, string user, string password)
{
sqlConnectionString = new SqlServerConnectionString()
{
Server = server,
Database = database,
User = user,
Password = password
};
}
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 generate_connectionString_with_Server_Database_and_TrustedConnection()
{
SqlServerConnectionString sqlConnectionString = new SqlServerConnectionString
{
Server = "server",
Database = "database",
TrustedConnection = true
};
string connectionString = sqlConnectionString.GetConnectionString();
Assert.AreEqual("Data Source=server;Initial Catalog=database;Trusted_Connection=True;", connectionString);
}
public void generate_connectionString_with_Server_Database_and_MultipleActiveResultSets()
{
SqlServerConnectionString sqlConnectionString = new SqlServerConnectionString
{
Server = "server",
Database = "database",
MultipleActiveResultSets = true
};
string connectionString = sqlConnectionString.GetConnectionString();
Assert.AreEqual("Data Source=server;Initial Catalog=database;MultipleActiveResultSets=True;", connectionString);
}
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 generate_connectionString_with_Server_Database_User_and_Password()
{
SqlServerConnectionString sqlConnectionString = new SqlServerConnectionString
{
Server = "server",
Database = "database",
User = "******",
Password = "******"
};
string connectionString = sqlConnectionString.GetConnectionString();
Assert.AreEqual("Data Source=server;Initial Catalog=database;User ID=user;Password=password;", connectionString);
}
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());
}
