private static void LoadQuestChains() { _questsByTitleAndPartCache = new Dictionary <string, QuestDAO>(); _questsByIdCache = new Dictionary <int, QuestDAO>(); //TODO error handlgn string sSql = $"SELECT * FROM {QuestDAO.TableName} ORDER BY {nameof(QuestDAO.ChainLevel)} "; var dataTable = SqlDriverFactory.GetSqlDriver(0).ExecuteQuery(sSql, null); var quests = dataTable.AsEnumerable().Select(QuestDAO.FromDataRow); foreach (var quest in quests) { _questsByIdCache[quest.QuestId] = quest; _questsByTitleAndPartCache[quest.QuestKey] = quest; } }
// Constructors public static StorageDriver Create(SqlDriverFactory driverFactory, DomainConfiguration configuration) { ArgumentValidator.EnsureArgumentNotNull(driverFactory, nameof(driverFactory)); ArgumentValidator.EnsureArgumentNotNull(configuration, nameof(configuration)); var driverConfiguration = new SqlDriverConfiguration { ForcedServerVersion = configuration.ForcedServerVersion, ConnectionInitializationSql = configuration.ConnectionInitializationSql, EnsureConnectionIsAlive = configuration.EnsureConnectionIsAlive, }; var driver = driverFactory.GetDriver(configuration.ConnectionInfo, driverConfiguration); var providerInfo = ProviderInfoBuilder.Build(configuration.ConnectionInfo.Provider, driver); return(new StorageDriver(driver, providerInfo, configuration, GetNullModel)); }
public static async Task <StorageDriver> CreateAsync( SqlDriverFactory driverFactory, DomainConfiguration configuration, CancellationToken token) { ArgumentValidator.EnsureArgumentNotNull(driverFactory, nameof(driverFactory)); ArgumentValidator.EnsureArgumentNotNull(configuration, nameof(configuration)); var driverConfiguration = new SqlDriverConfiguration { ForcedServerVersion = configuration.ForcedServerVersion, ConnectionInitializationSql = configuration.ConnectionInitializationSql, EnsureConnectionIsAlive = configuration.EnsureConnectionIsAlive, }; var driver = await driverFactory.GetDriverAsync(configuration.ConnectionInfo, driverConfiguration, token) .ConfigureAwait(false); var providerInfo = ProviderInfoBuilder.Build(configuration.ConnectionInfo.Provider, driver); return(new StorageDriver(driver, providerInfo, configuration, GetNullModel)); }
static Repository() { SqlDriverFactory.RegisterDriver(0, SqlDriverType.Sqlite, $"Data Source={DbFile};Version=3"); }