I have a question regarding opening connection is a asp .net server.
I am developing asp .net server with some APIs. These APIs can be called simultaneously from mobile.
If I open the connection every time I am updating\querying the db, wouldn't I get an exception that the connection is already opened when two APIs are called simultaneously? It can be a case, that an API will be called while other API call is in progress and using the db.
Can there be more than one opened connection to the db?