[Feature]: Integration tests and example app

[TylerReid]

Motivation

Integration tests would increase the confidence in future changes, and a local example using localstack for dynamodb would aid in debugging when working on the project.

Proposed solution

I have been prototyping using .Net Aspire for local development and integration testing in other projects. With aspire you can make a fully local development environment, and use the same setup for running tests locally and in CI.

I was thinking that there could be an examples directory containing a test api and the Aspire AppHost project, and in the tests directory a second project could be added for integration tests.

From my use so far the Aspire tests run very fast for end to end tests, so much so that just having it by default run with dotnet test is not a problem given its benefits.

I have been using localstack for other projects with many aws dependencies, but in this case there is also an AWS package that could be used: https://aws.amazon.com/blogs/developer/integrating-aws-with-net-aspire/

Would this be a welcome contribution?

[ncipollina]

@TylerReid of course. Please feel free to add.