public IEnumerable <SkycoreHRM.Shared.Department> GetData() { foreach (var strategy in Strategies) { try { IDbDataAdapter adapter = null; var accessContext = new DataAccessContext(strategy); adapter = accessContext.EstablishDataAccess(adapter); var myRenderer = new DataRenderer(adapter); var writer = new StringWriter(); myRenderer.Render(writer); var result = writer.ToString().Replace(" ", string.Empty); var rows = result.Split("\r\n").Where(e => !string.IsNullOrEmpty(e)); var departments = rows.Select(e => new SkycoreHRM.Shared.Department { Name = e }); return(departments); } catch (Exception) { continue; } } return(null); }