public DbProvider(string databaseName, SqliteSettings settings)
{
DatabaseName = databaseName;
_enforceForeignKeys = settings.EnforceForeignKeys;
_sqliteDatabasePath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Personal), databaseName);
_connectionProvider = new DbConnectionProvider(_sqliteDatabasePath, settings);
}
public DbConnectionProvider(string sqlFile, SqliteSettings sqliteSettings)
{
var dataSource = $"Data Source={sqlFile};";
var sqliteConnectionStringBuilder = new SqliteConnectionStringBuilder(dataSource)
{
CacheSize = sqliteSettings.CacheSize,
JournalMode = GetJournalMode(sqliteSettings.JournalMode),
PageSize = sqliteSettings.PageSize,
DefaultTimeout = (int)sqliteSettings.DefaultTimeout.TotalMilliseconds,
SyncMode = GetSyncMode(sqliteSettings.SyncMode),
FailIfMissing = sqliteSettings.FailIfMissing,
ReadOnly = sqliteSettings.ReadOnly,
};
_connectionString = sqliteConnectionStringBuilder.ConnectionString;
}