/// <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); }