public static void Initialize() { _engine = STSdb.FromFile(Config.Db); var regions = _engine.OpenXTable<int, AOCRegion>("regions"); var organisations = _engine.OpenXTable<int, AOCOrganisation>("organisations"); var users = _engine.OpenXTable<string, AOCUser>("users"); foreach (var o in Config.Organisations) { AOCOrganisation org = new AOCOrganisation() { ID = StringComparer.OrdinalIgnoreCase.GetHashCode(o), Name = o }; organisations[org.ID] = org; } Console.WriteLine("Added {0} organisations", organisations.Count()); foreach (var r in Config.Regions) { AOCRegion reg = new AOCRegion() { ID = StringComparer.OrdinalIgnoreCase.GetHashCode(r), Name = r }; regions[reg.ID] = reg; } Console.WriteLine("Added {0} regions", regions.Count()); foreach (var u in Config.Users) { users[u.Email] = u; } Console.WriteLine("Added {0} users", users.Count()); #if DEBUG var entries = _engine.OpenXTable<string, AOCEntry>("entries"); var names = new Dictionary<string, string>() { { "Julian", "Vallis"}, { "Tim", "Peet" }, { "Emma", "Baines" }, { "Rachel", "Gaskell" }, { "Karen", "Porter" }, { "Matt", "Cridland" }, { "Ross", "Hopcraft" }, { "Helene", "Dickson" }, { "April", "Felker" }, { "Fiona", "Vallis" }, { "Sandra", "Lim" }, { "Bilbo", "Baggins" }, { "Jeremy", "Paxman" }, { "Freddie", "Mercury" }, { "Mick", "Jagger" }, { "Keith", "Richards" }, { "Bill", "Wyman" }, { "Charlie", "Watts" }, { "Carlos", "Santana" }, { "Paul", "McCartney" }, { "John", "Lennon" }, { "James", "Bond" }, { "Sean", "Connery" }, { "George", "Lazenby" }, { "Roger", "Moore" }, { "Timothy", "Dalton" }, { "Pierce", "Brosnan" }, { "Daniel", "Craig" }, }; foreach (var name in names) { entries[name.Key.ToLowerInvariant() + "@bisqit.co.uk"] = new AOCEntry() { Answers = "1,2,3,4,1,2,3,4", Available = true, Email = name.Key.ToLowerInvariant() + "@bisqit.co.uk", FirstName = name.Key, LastName = name.Value, LineManager = "God", Organisation = "Bisqit", Reason = "Because...", Region = "London", Role = "God", Score = 10, Submitted = DateTime.UtcNow }; } #endif _engine.Commit(); }