public void Should_return_true_if_type_to_verify_is_as_the_one_expected() { var type = new SqlServerConnectionstringArguments(); var result = type.IsA<SqlServerConnectionstringArguments>(); Assert.IsTrue(result); }
public void Should_throw_an_exception_if_password_is_null_or_empty_and_username_is_not_null_or_empty() { var connectionstringArguments = new SqlServerConnectionstringArguments { DataSource = "DataSource", DatabaseName = "DatabaseName", Password = "", Provider = "Provider", Username = "******" }; _connectionstringArgumentsValidator.Validate(connectionstringArguments); }
public void Should_return_true_if_username_and_password_are_null_or_empty() { var connectionstringArguments = new SqlServerConnectionstringArguments { DataSource = "DataSource", DatabaseName = "DatabaseName", Provider = "Provider", }; var isValid = _connectionstringArgumentsValidator.Validate(connectionstringArguments); Assert.IsTrue(isValid); }
public void Should_be_able_to_build_a_sqlserver_connectionstring_whith_integrated_security() { var connectionstringArguments = new SqlServerConnectionstringArguments { DataSource = "TestDatabase", DatabaseName = "Test", Provider = "SQLOLEDB" }; var connectionstring = _connectionstringBuilderStrategy.BuildConnectionstring(connectionstringArguments); Assert.AreEqual("Provider=SQLOLEDB;Data Source=TestDatabase;Initial Catalog=Test;Integrated Security=SSPI;OLE DB Services=-4;", connectionstring); }
private static string BuildConnectionString(SqlServerConnectionstringArguments arguments) { string connectionString; if (string.IsNullOrEmpty(arguments.Username) && string.IsNullOrEmpty(arguments.Password)) { connectionString = string.Format("Provider={0};Data Source={1};Initial Catalog={2};Integrated Security=SSPI;OLE DB Services=-4;", arguments.Provider, arguments.DataSource, arguments.DatabaseName); } else { connectionString = string.Format("Provider={0};Data Source={1};Initial Catalog={2};User ID={3};Password={4};OLE DB Services=-4;", arguments.Provider, arguments.DataSource, arguments.DatabaseName, arguments.Username, arguments.Password); } return connectionString; }
public void Should_be_able_to_build_a_connection_string_for_sqlserver_databases() { var connectionstringArguments = new SqlServerConnectionstringArguments { Provider = "SQLOLEDB", DataSource = "localhost", DatabaseName = "TestDatabase", Password = "******", Username = "******" }; var connectionstring = _connectionstringFactory.BuildConnection(connectionstringArguments); Assert.AreEqual("Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=TestDatabase;User ID=username;Password=password;OLE DB Services=-4;", connectionstring); }
public void Should_be_able_to_build_a_sqlserver_connectionstring_when_username_and_password_are_specified() { var connectionstringArguments = new SqlServerConnectionstringArguments { DataSource = "TestDatabase", DatabaseName = "Test", Provider = "SQLOLEDB", Username = "******", Password = "******" }; var connectionstring = _connectionstringBuilderStrategy.BuildConnectionstring(connectionstringArguments); Assert.AreEqual("Provider=SQLOLEDB;Data Source=TestDatabase;Initial Catalog=Test;User ID=Username;Password=Password;OLE DB Services=-4;", connectionstring); }