private ConnectionBuilder GetDefaultConnection(ProjectName projectName, bool getAlternate = false) { var defaultServerName = "ZM-VLUS56"; var defaultSqlExpress = string.Empty; if (getAlternate) { defaultServerName = "D-5932S32"; defaultSqlExpress = "SQL2014"; } ConnectionBuilder connBuilder = null; switch (projectName) { case ProjectName.DOD: { connBuilder = new ConnectionBuilder() { DatabaseName = "JhpiegoDb_DOD", InstanceName = defaultSqlExpress, ServerName = defaultServerName }; break; } case ProjectName.IHP_VMMC: { connBuilder = new ConnectionBuilder() { DatabaseName = "JhpiegoDb_IhpVmmc", InstanceName = defaultSqlExpress, ServerName = defaultServerName }; break; } case ProjectName.IHP_Capacity_Building_and_Training: { connBuilder = new ConnectionBuilder() { DatabaseName = "JhpiegoDb_IhpTraining", InstanceName = defaultSqlExpress, ServerName = defaultServerName }; break; } } return(connBuilder); }
internal ConnectionBuilder SetProjectDatabase(ProjectName selectedProject) { _currentProjectName = selectedProject; return(ConnBuilder = GetDefaultConnection(_currentProjectName)); }
internal ConnectionBuilder GetAlternateConnection(ConnectionBuilder connBuilder) { return(GetDefaultConnection(_currentProjectName, true)); }
internal void OverwriteDefaultConnection(ConnectionBuilder connBuilder) { ConnBuilder = connBuilder; }
public DbHelper(ConnectionBuilder builder) { _connBuilder = builder; _connString = _connBuilder.GetConnectionString(); }