public static string CreateConnectionString(string path, string password = null, int?pageSize = null, bool?failIfMissing = null, SqliteJournalMode?journalMode = null, SqliteSyncMode?syncMode = null)
{
var connectionStringBuilder = new SQLiteConnectionStringBuilder();
if (!string.IsNullOrWhiteSpace(path))
{
connectionStringBuilder.DataSource = path;
}
if (!string.IsNullOrEmpty(password))
{
connectionStringBuilder.Password = password;
}
if (pageSize.HasValue)
{
connectionStringBuilder.PageSize = pageSize.Value;
}
if (failIfMissing.HasValue)
{
connectionStringBuilder.FailIfMissing = failIfMissing.Value;
}
if (journalMode.HasValue)
{
connectionStringBuilder.JournalMode = SqliteHelper.Convert(journalMode.Value);
}
if (syncMode.HasValue)
{
connectionStringBuilder.SyncMode = SqliteHelper.Convert(syncMode.Value);
}
return(connectionStringBuilder.ToString());
}
