Is it possible to have a data provider running on IIS and share amount login users?

Question

User1310405000 posted

I want to do so such that I can manage connections and reduce connection creation overhead, etc.

How am I able to do that?

Answer 1

User-481631678 posted

See this article, this will help you to understand connection managment:-

Tuning Up ADO.NET Connection Pooling in ASP.NET Applications

Answer 2

User1310405000 posted

Thank you, this article shed some light on my question.

I am wondering what the article described.

Does it means IIS is automatically handling connection pooling regarding the connection string?

If so, then I have some questions to ask.

1. What is there are two requests come to my server querying data from the database with different connection pool setting? What will happen to my pool?

2. Does it means new SqlConnection(connectionString); is acquiring connection from the pool and connection.Close(); means returning it?

3. What connections are in one pool? will different authentication end up in same pool? different login to the same database end up in same pool?

Answer 3

User1310405000 posted

I found my answers, thank you.