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

  • 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?

    Thursday, October 15, 2009 6:41 AM


All replies

  • User-481631678 posted

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

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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, October 15, 2009 10:12 AM
  • 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?

    Thursday, October 15, 2009 10:27 PM
  • User1310405000 posted

    I found my answers, thank you.

    Friday, October 16, 2009 12:24 AM