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