private static void CacheMunisTable(string tableName, string primaryKey, DbTransaction trans = null) { using (var results = MunisDatabase.ReturnSqlTable("SELECT * FROM " + tableName)) { results.TableName = tableName; SqliteFunctions.AddTableToCacheDB(results, primaryKey, trans); } }
private static void CacheFATable(DbTransaction trans = null) { using (var results = MunisDatabase.ReturnSqlTable(Queries.Munis.SelectAllScanItems())) { results.TableName = MunisFixedAssetTable.TableName; SqliteFunctions.AddTableToCacheDB(results, MunisFixedAssetTable.Asset, trans); } }
private static void CacheAssetTable(string tableName, string primaryKey, DbTransaction trans = null) { using (var results = DBFactory.GetMySqlDatabase().DataTableFromQueryString("SELECT * FROM " + tableName)) { results.TableName = tableName; SqliteFunctions.AddTableToCacheDB(results, primaryKey, trans); } }