/// <summary>
/// Defines the method to be called when the command is invoked.
/// </summary>
/// <param name="parameter">The connection parameter.</param>
public void Execute(object parameter)
{
DbConnectionParameter connectionParameter = (DbConnectionParameter)parameter;
IWrappedDbConnectionFactory connectionFactory = DbConnectionFactoryProvider.GetFactory(connectionParameter.Provider);
WrappedDbConnection dbConnection = null;
bool succeeded = false;
try {
dbConnection = connectionFactory.CreateConnection(connectionParameter);
succeeded = true;
}
catch (WrappedDbException) {
}
finally {
if (dbConnection != null)
{
dbConnection.Dispose();
}
}
if (succeeded)
{
MessageBox.Show("Connection succeeded", "Connection Test", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("Connection failed", "Connection Test", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
/// <summary>
/// Stores the current database connection parameter in the global variables
/// of the visual studio environment.
/// </summary>
/// <param name="dbConnectionParameter">The database connection parameter.</param>
internal void SaveDbConnectionParameterInGlobals(DbConnectionParameter dbConnectionParameter)
{
IWrappedDbConnectionFactory factory = DbConnectionFactoryProvider.GetFactory(dbConnectionParameter.Provider);
string providerName = factory.ProviderName;
string connectionString = factory.GetConnectionString(dbConnectionParameter);
Globals globals = application.Globals;
string variableName = CSqlConnectionFactory.CSqlConnectionProviderVariableName;
globals[variableName] = providerName;
globals.set_VariablePersists(variableName, true);
variableName = CSqlConnectionFactory.CSqlConnectionStringVariableName;
globals[variableName] = connectionString;
globals.set_VariablePersists(variableName, true);
}
public void GetOracleFactoryTest()
{
IWrappedDbConnectionFactory factory = DbConnectionFactoryProvider.GetFactory(ProviderType.Oracle);
Assert.IsInstanceOfType(factory, typeof(OracleConnectionFactory));
}
public void GetIbmDb2FactoryTest()
{
IWrappedDbConnectionFactory factory = DbConnectionFactoryProvider.GetFactory(ProviderType.IbmDb2);
Assert.IsInstanceOfType(factory, typeof(IbmDb2ConnectionFactory));
}
public void GetMsSqlFactoryTest()
{
IWrappedDbConnectionFactory factory = DbConnectionFactoryProvider.GetFactory(ProviderType.MsSql);
Assert.IsInstanceOfType(factory, typeof(MsSqlConnectionFactory));
}
