/// <summary>
/// Create and return the DDB Connection from the <see cref="_mappingSet"/> field
/// </summary>
/// <returns>
/// The DDB connection
/// </returns>
private DbConnection CreateDdbConnection()
{
// create ddb connection
string dissdbConnectionString = this._mappingSet.DataSet.Connection.AdoConnectionString;
string providerName = DatabaseType.GetProviderName(this._mappingSet.DataSet.Connection.DBType);
DbProviderFactory dbFactory = DbProviderFactories.GetFactory(providerName);
// for PC-axis it doesn't support DbFactory.CreateCommand() and the enteprise libs seem to call it
var disseminationDb = new GenericDatabase(dissdbConnectionString, dbFactory);
DbConnection ddbConnection = disseminationDb.CreateConnection();
ddbConnection.Open();
return ddbConnection;
}