The current project I'm working on is based on VB6, using a lot of inline SQL statements... My job is to come up with a POC for a redo in C# 2008 (ASP.NET). I'm thinking of using ES to get a head start with the DAL and Business Entities. One of the issues I'm facing is the following:

A customer logs in and through a default connection a lookup is performed to retrieve THAT customer's database server and catalog. From there on the application should work with the newly crafted connectionstring. Is it possible to model such dynamic connections in ES? Do you have any tips to get me started? Of course I want to do the lookup only once per session. After that the connection should be cached and reused (connection pool).

We do have what we call configless mode which allows you to create as many connections as you need at runtime. The tricky part is assigning them. Interesting enough we are doing some work in this area to make managing connections based on "namespace" easier, however, you bring up another interesting point, per user and in ASP.NET. What about making storing the "name" of the connection in the session. Perhaps we can add that as well. We have an excellent maintenance release coming out in a few weeks. This area is one of the area's we will be enhancing.

---

EntitySpaces | Twitter | BLOG | Please honor our Software License