Steps:
- Create Database
- Run CreateTable.sql (no data needed in the table)
- Add connection string to appsettings.json
- dotnet restore
- dotnet run
- open browser http://host:port/users?method=sql-client
- See that a response is generated
- Run performance tests, make 150 req/sec on windows -> no problem
- Run perfrmance tests, make 150 req/sec on none windows system -> high failure rate with: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 31 - Encryption(ssl/tls) handshake failed)
Tested with Azure Germany SQL