public void CanGetConnectionWithoutCredentials()
{
DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(TestConfigurationSource.CreateConfigurationSource());
ConnectionStringSettings data = settings.GetConnectionStringSettings("DbWithSqlServerAuthn");
SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString);
Assert.AreEqual(@"server=(localdb)\v11.0;database=northwind;", sqlDatabase.ConnectionStringWithoutCredentials);
}
public void CanGetConnectionForStringWithNoCredentials()
{
DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(TestConfigurationSource.CreateConfigurationSource());
ConnectionStringSettings data = settings.GetConnectionStringSettings("NewDatabase");
SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString);
Assert.AreEqual(@"server=(localdb)\v11.0;database=northwind;integrated security=true;", sqlDatabase.ConnectionStringWithoutCredentials);
}
public void ConnectionTest()
{
DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(TestConfigurationSource.CreateConfigurationSource());
ConnectionStringSettings data = settings.GetConnectionStringSettings("NewDatabase");
SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString);
DbConnection connection = sqlDatabase.CreateConnection();
Assert.IsNotNull(connection);
Assert.IsTrue(connection is SqlConnection);
connection.Open();
DbCommand cmd = sqlDatabase.GetSqlStringCommand("Select * from Region");
cmd.CommandTimeout = 60;
Assert.AreEqual(cmd.CommandTimeout, 60);
}
public void CheckNoPasswordInConnectionStringWithPersistInfoEqualsFalse()
{
try
{
CreateUser();
DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(TestConfigurationSource.CreateConfigurationSource());
ConnectionStringSettings data = settings.GetConnectionStringSettings("NorthwindPersistFalse");
SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString);
DbConnection dbConnection = sqlDatabase.CreateConnection();
dbConnection.Open();
dbConnection.Close();
string connectionString = dbConnection.ConnectionString;
if (connectionString.ToLower().Contains("pwd") || connectionString.ToLower().Contains("password"))
{
Assert.Fail();
}
}
finally
{
DeleteUser();
}
}
