private DBType GetDatabaseTypeFromString(string databaseConnectionString) { string FUNCTION_NAME = "GetDatabaseTypeFromString"; LogHelper.Trace(CLASS_NAME, FUNCTION_NAME, "Function_Entered"); //connection string will have dbtype at the first of the string with ';' as delimiter. string dbTypeString = databaseConnectionString.Substring(0, databaseConnectionString.IndexOf(DAOHelper.DB_Delimiter)); DBType dbType = DAOHelper.GetDbType(dbTypeString); LogHelper.Debug(CLASS_NAME, FUNCTION_NAME, string.Format("Database Type = {0}", dbType.ToString())); return(dbType); }
private DBType GetDatabaseTypeFromString(string databaseConnectionString) { string FUNCTION_NAME = "GetDatabaseTypeFromString"; LogHelperCli.GetInstance().Log_Generic(CLASS_NAME + "." + FUNCTION_NAME, LogHelperCli.GetInstance().GetLineNumber(), EDebugLevelManaged.DebugInfo, "Function Entered."); //connection string will have dbtype at the first of the string with ';' as delimiter. string dbTypeString = databaseConnectionString.Substring(0, databaseConnectionString.IndexOf(DAOHelper.DB_Delimiter)); DBType dbType = DAOHelper.GetDbType(dbTypeString); LogHelperCli.GetInstance().Log_Generic(CLASS_NAME + "." + FUNCTION_NAME, LogHelperCli.GetInstance().GetLineNumber(), EDebugLevelManaged.DebugInfo, string.Format("Database Type = {0}", dbType.ToString())); return(dbType); }
private string getConnectionStringBasedType(string configFile, string dbLabel) { string connectionString; DBType dbType = DAOHelper.GetDbType(GetINIDataString(dbLabel, "DB_TYPE", "", 255, configFile)); if (dbType == DBType.Oracle) { connectionString = GetINIDataString(dbLabel, "DB_TYPE", "", 255, configFile) + ";Data Source = " + GetINIDataString(dbLabel, "SERVICE_NAME", "", 255, configFile) + ";" + "User Id = " + GetINIDataString(dbLabel, "USER_ID", "", 255, configFile) + "; " + "Password = "******"USER_PASSWORD", "", 255, configFile) + "; "; } else { connectionString = GetINIDataString(dbLabel, "DB_TYPE", "", 255, configFile) + ";Database = " + GetINIDataString(dbLabel, "SERVICE_NAME", "", 255, configFile) + ";" + "User Id = " + GetINIDataString(dbLabel, "USER_ID", "", 255, configFile) + "; " + "Password = "******"USER_PASSWORD", "", 255, configFile) + ";Host = " + GetINIDataString(dbLabel, "HOST_NAME", "", 255, configFile) + ";Port=3306;"; } return(connectionString); }