feat: support negative indexing (#336)

* feat: support negative indexing

* fix: ensure db deleted before creating new db context

* fix: split in memory db name

feat: bind PagingParams from route values (#335)

* feat: bind PagingParams from route values

* refactor: remove unnecessary pageIndex and pageSize check

refactor: reuse default SerializerOptions in Minimal APIs (#334)

* test: add test case to reproduce encoded Chinese characters

* refactor: reuse default SerializerOptions in Minimal APIs

refactor: use built-in json options in Minimal APIs

Bump Microsoft.AspNetCore.Mvc.Testing from 9.0.8 to 9.0.9 (#329)

---
updated-dependencies:
- dependency-name: Microsoft.AspNetCore.Mvc.Testing
  dependency-version: 9.0.9
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

Bump Microsoft.AspNetCore.Mvc.Testing from 9.0.8 to 9.0.9 (#329)

---
updated-dependencies:
- dependency-name: Microsoft.AspNetCore.Mvc.Testing
  dependency-version: 9.0.9
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

refactor: introduce MediatR configuration parameter to AddCqrs

feat: register generic handlers

fix: isolate clickhouse db connection factory between different click…

…house db contexts (#327)

chore: remove FluentAssertions (#326)

* chore: remove FluentAssertions

* chore: drop net8 support

* feat: add datetime calculator methods

* chore: remove script