CloseConnections() seems not working (v2020)

ASP.NET Maker General Discussion (ASP.NET Maker)
1

I am using asp.net maker 2020, I hosted my application on the server but encountered a problem which is that the number of connections in the SQL database server is always increasing. I tried to check the problem locally and found the same thing. I Tried to check the application in the Visual Studio (using debug) and find the CloseConnections () function as if it has no effect. I did update template but sill the same. Please help

2

Possibly related to garbage collection. Read:
https://discourse.hkvstore.com/t/timeout-expired-because-all-pooled-connections-were-in-use/2038/1

3

I managed to reduce the number of sleeping sessions by placing a call to close connections on UserID_Loaded()

public void UserID_Loaded() {
	//Log("UserID Loaded: {UserIDList}", UserIDList());
	CloseConnections();
	Collect();

I had calls to the users table which remained in a sleeping state, although the page/permissions checks loaded correctly.
I’m still pestered by a large amount of connections with SET DATEFORMAT ymd.

It would be great if we could turn-off this one (in advanced settings), as most of the SQL Servers are deployed in the default collation.