/// <summary>
/// Create Database ObjectBy Configured Name
/// </summary>
/// <param name="configDatabaseKey">Configuration Database Key.</param>
/// <returns>Database driver.</returns>
public IDbDriver CreateDatabaseObjectByConfiguredName(string configDatabaseKey)
{
IDbDriver instance = null;
Configuration config = Configuration.GetNewInstance();
DataRow[] result = config.DatabaseConnections.Select("Name='" + configDatabaseKey + "'");
if (result.Length == 1)
{
Epi.DataSets.Config.DatabaseRow dbConnection = (Epi.DataSets.Config.DatabaseRow)result[0];
OleDbConnectionStringBuilder cnnBuilder = new OleDbConnectionStringBuilder("Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=1;RetrieveIds=Yes;");
instance = CreateDatabaseObject(cnnBuilder);
}
else
{
throw new GeneralException("Database name is not configured.");
}
return(instance);
}
public IDbDriver CreateDatabaseObjectByConfiguredName(string configDatabaseKey)
{
//may not use since PHIN is .MDB
IDbDriver instance = null;
Configuration config = Configuration.GetNewInstance();
DataRow[] result = config.DatabaseConnections.Select("Name='" + configDatabaseKey + "'");
if (result.Length == 1)
{
Epi.DataSets.Config.DatabaseRow dbConnection = (Epi.DataSets.Config.DatabaseRow)result[0];
EpiWebConnectionStringBuilder MongoDBConnectionBuilder = new EpiWebConnectionStringBuilder(dbConnection.ConnectionString);
instance = CreateDatabaseObject(MongoDBConnectionBuilder);
}
else
{
throw new GeneralException("Database name is not configured.");
}
return(instance);
}
/// <summary>
/// Create Database ObjectBy Configured Name
/// </summary>
/// <param name="configDatabaseKey">Configuration Database Key.</param>
/// <returns>Database driver.</returns>
public IDbDriver CreateDatabaseObjectByConfiguredName(string configDatabaseKey)
{
IDbDriver instance = null;
Configuration config = Configuration.GetNewInstance();
DataRow[] result = config.DatabaseConnections.Select("Name='" + configDatabaseKey + "'");
if (result.Length == 1)
{
Epi.DataSets.Config.DatabaseRow dbConnection = (Epi.DataSets.Config.DatabaseRow)result[0];
OleDbConnectionStringBuilder cnnBuilder = new OleDbConnectionStringBuilder();
cnnBuilder.DataSource = dbConnection.ConnectionString;
//ToDo: Change code to read the configuration file, need to add provider information into the configuration file.
cnnBuilder.Provider = "Microsoft.ACE.OLEDB.12.0"; //Zack: here just hard coded for debug
instance = CreateDatabaseObject(cnnBuilder);
}
else
{
throw new GeneralException("Database name is not configured.");
}
return(instance);
}
