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