public string CreateConnectionString(IDatabaseConnectionServiceModel databaseConnectionServiceModel)
{
if (string.IsNullOrWhiteSpace(databaseConnectionServiceModel.ServerInstance))
{
throw new SmartResponseException("Server Instance was not provided.", ResponseStatusCode.PreconditionFailed);
}
if (!databaseConnectionServiceModel.HasIntegratedSecurity)
{
if (string.IsNullOrWhiteSpace(databaseConnectionServiceModel.Username))
{
throw new SmartResponseException("Username was not provided.", ResponseStatusCode.PreconditionFailed);
}
if (string.IsNullOrWhiteSpace(databaseConnectionServiceModel.Password))
{
throw new SmartResponseException("Password was not provided.", ResponseStatusCode.PreconditionFailed);
}
}
return(new SqlConnectionStringBuilder
{
DataSource = databaseConnectionServiceModel.ServerInstance,
InitialCatalog = databaseConnectionServiceModel.DatabaseName,
IntegratedSecurity = databaseConnectionServiceModel.HasIntegratedSecurity,
UserID = databaseConnectionServiceModel.Username,
Password = databaseConnectionServiceModel.Password
}.ToString());
}
public DatabaseConnectionAdapter(IDatabaseConnectionServiceModel databaseConnection)
{
_databaseConnection = databaseConnection;
}
public static string CreateConnectionString(IDatabaseConnectionServiceModel connectionCredentails, ConnectionStringType connectionStringType)
{
var connectionStringBuilder = ConnectionManipulatorFactory.GetConnectionStringBuilder(connectionStringType);
return(connectionStringBuilder.CreateConnectionString(connectionCredentails));
}
