How to keep single sql connection instance open for multiple request in c#? : I have web api which contains database insertion logic(ado.net) in c#. When multiple users(e.g. 100 users) call the web api, everytime sql connection is open and closed for multiple request. it slows down performance. How can I keep single sql connection live for multiple request? I have to keep sql connection open only once and close after some time so that during that time it should consider multiple request and insert records in database.

Please suggest. 