Dynamic Connection Strings, LINQ to SQL, and Connection Pooling? RRS feed

  • Question

  • I have an application that has a single authentication database for all my users.  Each set of Users has their own database.  A set of users is about 100 people.  When the user logs in, I get the new connection string and use this in all my LINQ to SQL connections.  The question and or problem is are my connections being pooled?

    Each method in my DAL layer starts like this:

    EntitiesDataContext db = new EntitiesDataContext(sessionData.UserConnectionString);

    Monday, August 6, 2012 4:43 PM