SurrealDB test stability

[aaronpowell]

The tests for the SurrealDB client integration are not always successful on the first run, it looks like something is timing out when releasing a connection, see here for an example.

The test results asset contains a dump file that might help understand what isn't being released.

[aaronpowell]

@Odonno are you able to have a look at this?

[Odonno]

I will look into it, is it happening after the .NET 10 migration?

[Odonno]

I can reproduce this issue locally but the SurrealDb client looks correctly disposed and I don't see the reason why it would fail now. The issue seems to happen in the xUnit lib but I can't really find the reason.

It seems this issue already happened before; https://github.com/CommunityToolkit/Aspire/actions/runs/18860191028/job/53816804836

Maybe the perfect time to migrate to xUnit v3?

[aaronpowell]

Maybe the perfect time to migrate to xUnit v3?

I did start that but I haven't had time (and the github reporter wasn't working but I think that's close to resolved)

[aaronpowell]

I think it is something related to the .NET 10 upgrade, but I don't know how to effectively read a dump file 😅