public IEnumerable <UmbracoKeyValue> GetKeyValues() { using (var scope = this.scopeProvider.CreateScope(autoComplete: true)) { var schemaCreator = new Umbraco.Core.Migrations.Install.DatabaseSchemaCreator(scope.Database, this.logger); if (schemaCreator.TableExists("umbracoKeyValue")) { const string sql = @" SELECT [key], [value], Updated FROM umbracoKeyValue ORDER BY Updated"; return(scope.Database.Fetch <UmbracoKeyValue>(sql)); } } return(null); }
public IEnumerable <ServerModel> GetRegistredServers() { using (var scope = this.scopeProvider.CreateScope(autoComplete: true)) { var schemaCreator = new Umbraco.Core.Migrations.Install.DatabaseSchemaCreator(scope.Database, this.logger); if (schemaCreator.TableExists("umbracoServer")) { const string sql = @"SELECT Id, Address, ComputerName, RegisteredDate, LastNotifiedDate, IsActive, IsMaster FROM umbracoServer"; return(scope.Database.Fetch <ServerModel>(sql)); } } return(null); }