/// <inheritdoc />
 public override void Dispose()
 {
     SelectEntryArtists.Dispose();
     SelectEntryCharacters.Dispose();
     SelectEntrySeries.Dispose();
     SelectEntryTags.Dispose();
     Repository = null;
     base.Dispose();
 }
        protected EntryPagination(MetadataRepository repository)
        {
            Repository = repository;

            SelectEntryArtists      = repository.Sql.CreateCommand(QueryManager.Instance.SelectEntryArtists);
            SelectEntryArtistsEntry = SelectEntryArtists.CreateParameter("$entry");

            SelectEntryCharacters      = repository.Sql.CreateCommand(QueryManager.Instance.SelectEntryCharacters);
            SelectEntryCharactersEntry = SelectEntryCharacters.CreateParameter("$entry");

            SelectEntrySeries      = repository.Sql.CreateCommand(QueryManager.Instance.SelectEntrySeries);
            SelectEntrySeriesEntry = SelectEntrySeries.CreateParameter("$entry");

            SelectEntryTags      = repository.Sql.CreateCommand(QueryManager.Instance.SelectEntryTags);
            SelectEntryTagsEntry = SelectEntryTags.CreateParameter("$entry");

            SelectEntryPages      = repository.Sql.CreateCommand(QueryManager.Instance.SelectEntryPages);
            SelectEntryPagesEntry = SelectEntryPages.CreateParameter("$entry");
        }