public SpinerBaseRep(Connection p_connection) { clsConfiguration dataBaseConfig; try { this.connection = p_connection; dataBaseConfig = new clsConfiguration(); if (p_connection.Instance.Trim() != "") { dataBaseConfig.Server = p_connection.Server + "/" + p_connection.Instance; } else { dataBaseConfig.Server = p_connection.Server; } if (p_connection.DataBaseType == enmDataBaseType.MsSQL) { dataBaseConfig.Type = DataBase.enmDataBaseType.MsSql; } else if (p_connection.DataBaseType == enmDataBaseType.MySQL) { dataBaseConfig.Type = DataBase.enmDataBaseType.MySql; } else if (p_connection.DataBaseType == enmDataBaseType.SQLite) { dataBaseConfig.Type = DataBase.enmDataBaseType.SqLite; dataBaseConfig.Server = p_connection.Server + "\\" + p_connection.DataBase; } else if (p_connection.DataBaseType == enmDataBaseType.Oracle) { dataBaseConfig.Type = DataBase.enmDataBaseType.Oracle; } else { dataBaseConfig.Type = DataBase.enmDataBaseType.Postgre; } dataBaseConfig.DataBase = p_connection.DataBase; dataBaseConfig.User = p_connection.User; dataBaseConfig.Password = p_connection.Password; dataBaseConfig.ConnetionTimeout = 5; objDataBase = DataBase.fnOpenConnection(dataBaseConfig); } catch (Exception ex) { throw ex; } }
public BucketReportRep(string dbFile) { clsConfiguration config; try { config = new clsConfiguration(); config.DataBase = dbFile; config.Server = dbFile; config.Type = DataBase.enmDataBaseType.SqLite; dataBase = DataBase.fnOpenConnection(config); initializeDataBase(); } catch (Exception) { throw; } }