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(); } }