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);
}
