public static void Refresh()
{
Preferences = AppSettings.HelperTableOptions;
IEnumerable <Site> sites;
_cache.Clear();
if (Preferences == null)
{
return;
}
if (!Preferences.PerSite)
{
sites = Current.DB.Query <Site>("SELECT TOP 1 * FROM Sites");
}
else
{
sites = Current.DB.Sites.All();
}
foreach (var site in sites)
{
IEnumerable <TableInfo> tables = site.GetTableInfos();
var tablesCache = new Dictionary <string, ResultSet>();
foreach (var table in tables)
{
if (_tableMatcher.IsMatch(table.Name))
{
using (SqlConnection connection = site.GetOpenConnection()) {
tablesCache[table.Name] = GetTableResults(connection, table);
}
}
}
_cache[site.TinyName] = tablesCache;
}
}
public static void Refresh()
{
Preferences = AppSettings.HelperTableOptions;
IEnumerable<Site> sites;
cache.Clear();
if (Preferences == null)
{
return;
}
if (!Preferences.PerSite)
{
sites = Current.DB.Query<Site>("SELECT TOP 1 * FROM Sites");
}
else
{
sites = Current.DB.Sites.All();
}
foreach (var site in sites)
{
IEnumerable<TableInfo> tables = site.GetTableInfos();
var tablesCache = new Dictionary<string, ResultSet>();
foreach (var table in tables) {
if (tableMatcher.IsMatch(table.Name))
{
using (var connection = site.GetOpenConnection()) {
tablesCache[table.Name] = GetTableResults(connection, table);
}
}
}
cache[site.TinyName] = tablesCache;
}
}